Skip to content

Instantly share code, notes, and snippets.

@nazmul629
Last active March 4, 2020 15:26
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 nazmul629/95837fb54c8ca6971d3cd6354f7bcd60 to your computer and use it in GitHub Desktop.
Save nazmul629/95837fb54c8ca6971d3cd6354f7bcd60 to your computer and use it in GitHub Desktop.
This gist for Command of basic PostgreSQL.

For see Status

service postgresql status

Connect With database

sudo su postgres

Give your OS Root Password

Show all Database

\l

Show All of the Database Users

\du

Connect With database

\connect database_name

Show all Data table

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