[prev] 29 [next]

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