Postgres Cheatsheet

2022-04-28T06:00:25+00:00

• get list of functions for current db in psql
  • \df
• display the definition of the custom function
  • \sf some_function
• turn on expanded display
  • \x
• generate schema of a database
  • pg_dump -t 'public.information' --schema-only what_i_learned