Hi.
What is the table in postgresql that stores the list openerp databases ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
5
Replies
13546
Views
If you wan to list all the databases, then just enter psql -l from terminal. It will list all databases.
Open Terminal
test@example:~$ sudo su postgres
[sudo] password for test:
postgres@example:/home/test$ psql
psql (9.5.10)
Type "help" for help.
postgres=# \l
Thanks !
enter psql -l from terminal
Login as postgres user in terminal:
sudo su postgres
... and then
psql -l
for list all databases
You can all you databases (not only those ones that are OpenERP ones) by running this SQL request : "SELECT datname FROM pg_catalog.pg_database"
