See table sql definition

How can we see the sql definition of a table? See column types, primary keys, constraints, etc.


Welcome to and thanks for posting!

The UI does not display table definitions although you can expand table entries in the navigation bar to show the column types and names. You can also add descriptions. We don’t have near term plans to expand what you can see in the UI. If you’d like to see full table definitions, I suggest psql via

or another tool like Postico 2 to get the DDL for a particular table. Finally, since provides standard regular Postgres, you can query the information_schema or pg_catalog to get the information you need.