Catalogs (cont)
You can explore the PostgreSQl catalog via psql commands
-
\d gives a list of all tables and views
-
\d Table gives a schema for Table
-
\df gives a list of user-defined functions
-
\df+ Function gives details of Function
-
\ef Function allows you to edit Function
-
\dv gives a list of user-defined views
-
\d+ View gives definition of View
You can also explore via SQL on the catalog tables
|