SanthoshBabuMR/postgresql.sql

Last active August 18, 2020 04:29

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/SanthoshBabuMR/c64b3fcc2522ff614fd5ce3fbc4eae57.js"></script>
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