3 ms·
Here's your schema from Postgres: pg_dump -s your_db | less Or you can explore it using `psql`: $ psql your_db List schemas: your_db=# \dn Lis
by yawaramin 10y ago
Here's your schema from Postgres:
pg_dump -s your_db | less
Or you can explore it using `psql`:
$ psql your_db
List schemas:
your_db=# \dn
List tables in a schema:
your_db=# \dt public.
Show table detailed info (constraints, indexes, comments, etc.):
your_db=# \dt+ your_table
List functions:
your_db=# \df
Or you can install pgAdmin and browse through the entire database--tables, constraints, indexes, the whole shebang--in a single screen. At no point are the migrations burying the schema. That's just a fundamental misunderstanding of how to work with databases.