Postgres data structure


(SMHassanAlavi) #1

Hi.how can I connect to postgres database and see the structure and tables in ubuntu terminal.I want to write a plugin but I don’t khow the database structures


(Robin Ward) #2

Assuming you’re using our docker install:

./launcher enter app
rails db

If you’ve got a development environment set up, just rails db should do it.


(SMHassanAlavi) #3

thank you but how can I see tables?and data bases


(Rafael dos Santos Silva) #4

http://postgresguide.com/utilities/psql.html


(Jay Pfaffman) #5

Try the data Explorer plugin.


(SMHassanAlavi) #6

Is site language saved in database?
where?


(Alex) #7

Changing the locale from the default English one creates a row in the site_settings table.

After changing it for example to German, the default_locale record is created: