Postgres data structure

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

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.

2 Likes

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

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

5 Likes

Try the data Explorer plugin.

2 Likes

Is site language saved in database?
where?

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:

3 Likes