Skip to content

Instantly share code, notes, and snippets.

@shams-ali

shams-ali/postgres.sh

Created June 30, 2016 18:58
Show Gist options
  • Save shams-ali/9259595fcf1506711e6df8187078178e to your computer and use it in GitHub Desktop.
Save shams-ali/9259595fcf1506711e6df8187078178e to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Commands
Raw
postgres.sh
#show schemas
\dt
#show all rows and collumns
SELECT * FROM [table];
#remove duplicates
SELECT DISTINCT [collumn] FROM [TABLE]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment