Postgres Cheatsheet

1. Cheatsheets
2. Postgres

Overview

• Relational
• Support for JSON columns
• Not case sensitive
• Postgres for Mac: http://postgresapp.com/

~/Applications/Postgres.app/Contents/MacOS/bin/createuser -s chris

Commands in psql

Command	Actions
\l	List all databases
\c dbname	Connect to new database
\dt	View list of relations/tables
\h	Get a help on syntax of SQL commands
\?	Lists all psql slash commands.
\set	System variables list.
\q	Quit psql

Connecting

http://postgresapp.com/documentation/

Connection parameters When using a GUI program, here are the connection parameters you need to enter:

Host: localhost Port: 5432 (default) User: your user name Password: blank Database: same as user name If you need to provide an URL (eg. for Induction), use postgresql://YOURUSERNAME@localhost/YOURUSERNAME

GUI Tools

PG Commander

https://eggerapps.at/pgcommander/

PG Admin

http://www.pgadmin.org/

Common pitfalls

• Not including the path. ** Add to the ~/.bash_profile and use source ~/.bash_profile to reset it on the current terminal.

---

blog comments powered by Disqus