# Postgres data structure
**URL:** https://meta.discourse.org/t/postgres-data-structure/52374
**Category:** Development
**Created:** [November 2, 2016, 1:21pm UTC](https://meta.discourse.org/t/postgres-data-structure/52374 "2016-11-02T13:21:00Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Alavi1412](https://meta.discourse.org/u/Alavi1412)
#### Post date: [November 2, 2016, 1:21pm UTC](https://meta.discourse.org/t/postgres-data-structure/52374/1 "2016-11-02T13:21:00Z")
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
---
### Author:  [@eviltrout](https://meta.discourse.org/u/eviltrout)
#### Post date: [November 2, 2016, 2:35pm UTC](https://meta.discourse.org/t/postgres-data-structure/52374/2 "2016-11-02T14:35:03Z")
Assuming you’re using our docker install:
```plaintext
./launcher enter app
rails db
```
If you’ve got a development environment set up, just `rails db` should do it.
---
### Author:  [@Alavi1412](https://meta.discourse.org/u/Alavi1412)
#### Post date: [November 2, 2016, 2:42pm UTC](https://meta.discourse.org/t/postgres-data-structure/52374/3 "2016-11-02T14:42:34Z")
thank you but how can I see tables?and data bases
---
### Author:  [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [November 2, 2016, 3:07pm UTC](https://meta.discourse.org/t/postgres-data-structure/52374/4 "2016-11-02T15:07:16Z")
> [@Alavi1412](#):
>
> thank you but how can I see tables?and data bases
> **[Psql](https://www.postgresguide.com/utilities/psql/)**
>
> What is psql Psql is the interactive terminal for working with Postgres. Theres an abundance of flags available for use when working with psql, but lets focus on some of the most important ones, then how to connect:
> -h the host to connect to
> ...
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [November 8, 2016, 4:45am UTC](https://meta.discourse.org/t/postgres-data-structure/52374/5 "2016-11-08T04:45:23Z")
Try the [data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin.
---
### Author:  [@Alavi1412](https://meta.discourse.org/u/Alavi1412)
#### Post date: [December 31, 2016, 7:06am UTC](https://meta.discourse.org/t/postgres-data-structure/52374/6 "2016-12-31T07:06:46Z")
Is site language saved in database?
where?
---
### Author:  [@AlexD](https://meta.discourse.org/u/AlexD)
#### Post date: [January 1, 2017, 9:05pm UTC](https://meta.discourse.org/t/postgres-data-structure/52374/7 "2017-01-01T21:05:14Z")
[Changing the locale](http://blog.discourse.org/2013/03/localizing-discourse/) 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:
