Skip to content

Instantly share code, notes, and snippets.

@SanthoshBabuMR

SanthoshBabuMR/postgresql.sql

Last active August 18, 2020 04:29
Show Gist options
  • Save SanthoshBabuMR/c64b3fcc2522ff614fd5ce3fbc4eae57 to your computer and use it in GitHub Desktop.
Save SanthoshBabuMR/c64b3fcc2522ff614fd5ce3fbc4eae57 to your computer and use it in GitHub Desktop.
Download ZIP
postgresql cheatsheet
Raw
postgresql.sql
# Connect to psql
psql -d <db_name>
# show current DB
/c
# switch DB
/c <db_name>
# create DB
CREATE DATABASE <db_name>
# list tables
/dt
# quit psql
/q
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment