Skip to content

Instantly share code, notes, and snippets.

@yakuter

yakuter/postgres.md

Last active August 19, 2020 05:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yakuter/7d49cdd39f0c7c2eb2c5d2b01d7a4351 to your computer and use it in GitHub Desktop.
Save yakuter/7d49cdd39f0c7c2eb2c5d2b01d7a4351 to your computer and use it in GitHub Desktop.
Download ZIP
Usefull Postgresql Commands
Raw
postgres.md

Usefull Postgresql Commands

Show databases \l

Choose database \c passwall

List tables \dt

List schemas \dn

Quit \q

Drop table DROP TABLE bank_accounts CASCADE;

Select a schema SET search_path TO user1;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment