This repository was archived by the owner on Oct 17, 2020. It is now read-only.

Postgres notes

Jump to bottom

avilaton edited this page Jul 28, 2014 · 1 revision

postgres notes

load from file

\i database/cba-0.1.5.sql

dump to csv

\COPY stops TO 'stops.txt' WITH delimiter ',' null '' csv header quote '"';

push to heroku

PGUSER=*** PGPASSWORD=*** heroku pg:push cbadb HEROKU_POSTGRESQL_PINK --app gtfseditor