forked from conveyal/gtfs-editor
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathexport-database.sql
More file actions
15 lines (15 loc) · 894 Bytes
/
export-database.sql
File metadata and controls
15 lines (15 loc) · 894 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
-- Create a database dump
\copy agency TO 'agency.csv' WITH CSV HEADER;
\copy route TO 'route.csv' WITH CSV HEADER;
\copy (SELECT *, ST_X(location) lon, ST_Y(location) lat FROM stop) to 'stop.csv' WITH CSV HEADER;
\copy routetype TO 'routetype.csv' WITH CSV HEADER;
\copy scheduleexception TO 'exception.csv' WITH CSV HEADER;
\copy scheduleexception_dates TO 'exception_dates.csv' WITH CSV HEADER;
\copy scheduleexception_servicecalendar TO 'exception_calendars.csv' WITH CSV HEADER;
\copy servicecalendar TO 'servicecalendar.csv' WITH CSV HEADER;
\copy trip TO 'trip.csv' WITH CSV HEADER;
\copy trippattern TO 'trippattern.csv' WITH CSV HEADER;
\copy trippatternstop TO 'patternstop.csv' WITH CSV HEADER;
\copy stoptime TO 'stoptime.csv' WITH CSV HEADER;
\copy account TO 'account.csv' WITH CSV HEADER;
\copy (SELECT id, ST_AsText(shape) shape FROM tripshape) TO 'shapes.csv' WITH CSV HEADER;