log in on psql console:
sudo -u postgres psql postgres
\q- quit ini console
\l - databases
\c mydb - use this db
\dt - tables
\d my mytable - show columns in mytable
Last active
December 14, 2015 09:52
-
-
Save g-ilham/cac03e0362bdd9c485b2 to your computer and use it in GitHub Desktop.
postgres cheatsheet
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment