mirror of
https://github.com/dimitri/pgloader.git
synced 2026-01-21 15:11:01 +01:00
3f2f10eef1
Add a link to the table from the internal catalogs for columns so that we can match table-source-name in cast rules when migrating from PostgreSQL.
15 lines
447 B
Fish
15 lines
447 B
Fish
load database
|
|
from pgsql:///hackathon
|
|
into pgsql://localhost:9700/dim
|
|
|
|
with include drop, reset no sequences
|
|
|
|
cast column impressions.seen_at to "timestamp with time zone"
|
|
|
|
distribute companies using id
|
|
-- distribute campaigns using company_id
|
|
-- distribute ads using company_id from campaigns
|
|
-- distribute clicks using company_id from ads, campaigns
|
|
-- distribute impressions using company_id from ads, campaigns
|
|
;
|