Odoo Help

0

Openerp database list in postgresql

By
ThackerS (ts)
on 8/13/14, 8:31 AM 1,924 views

Hi.

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

10

Janeesh

--Janeesh--

4335
| 5 3 6
Cochin, India
--Janeesh--

Odoo Developer

Janeesh
On 8/13/14, 9:19 AM

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

2

Roy Mathew

--Roy Mathew--

992
| 2 0 3
London, United Kingdom
--Roy Mathew--


Roy Mathew
On 9/22/17, 3:05 AM

enter psql -l from terminal

1
Quentin THEURET
On 8/13/14, 9:06 AM

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"

0



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 !

Shameem Babu @ iWesabe 

0
Carlos
On 1/31/18, 2:39 PM

Login as postgres user in terminal:

sudo su postgres

... and then

psql -l

for list all databases

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 8/13/14, 8:31 AM
Seen: 1924 times
Last updated: 2/1/18, 12:06 AM