Skip to content

Instantly share code, notes, and snippets.

@torsday

torsday/postgres.md

Created August 22, 2013 23:45
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save torsday/6314081 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save torsday/6314081 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL #db #notes
Raw
postgres.md

PostgreSQL

Basics

List Databases

$ psql -l

Open up database

$ psql <database-name>

List Tables

> \d

Show Table Structure

> \d <table-name>

Basic statements

> select * from <table-name>

Quit

\q

Help

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