PostgreSQL Quick Reference
Connect $ psql -h localhost -d mydb -U myuser List Databases From within a psql session: l List Tables dt Connect To DB c myuser Execute SQL in a File $ psql -U myuser -d mydb -a -f myfile.sql Run a Query $ psql -U myuser -d mydb -c ‘SELECT * FROM my_table’ Output to […]