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

• output query to a file

  • \o /tmp/output.txt
  • select * from adani_modi_downfall_story
  • \o

• create a new database from an existing database

  • CREATE DATABASE newdb WITH TEMPLATE originaldb OWNER dbuser;