search

NYCPlanning / ae-data-flow

Data pipelines to populate Application Engineering databases
1 stars 0 forks source link

update tables in an API DB #28

Closed damonmcc closed 3 months ago

damonmcc commented 3 months ago

Once we populate API tables in a Data Flow database, we must update the same tables in an API database.

approach ideas

One idea is to export and import csvs.

Another is to use pg_dump to export "archives" of each table and pg_restore to import them.