Skip to Content
Menu
This question has been flagged
5 Replies
15423 Rodiniai

Hi.

What is the table in postgresql that stores the list openerp databases ?

Portretas
Atmesti
Best Answer

If you wan to list all the databases, then just enter psql -l from terminal. It will list all databases.

Portretas
Atmesti
Best Answer



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 !


iWesabe 

Portretas
Atmesti
Best Answer

enter psql -l from terminal

Portretas
Atmesti
Best Answer

Login as postgres user in terminal:

sudo su postgres

... and then

psql -l

for list all databases

Portretas
Atmesti
Best Answer

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"

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
1
liep. 23
5055
1
bal. 20
11894
1
kov. 15
4618
0
birž. 24
981
0
geg. 24
696