Revision 10151
Added by Aaron Marcuse-Kubitza over 11 years ago
lib/runscripts/table.run | ||
---|---|---|
47 | 47 |
echo_func; set_make_vars |
48 | 48 |
table_make map.csv |
49 | 49 |
psql <<EOF |
50 |
SELECT util.reset_map_table('pg_temp.map');
|
|
51 |
ALTER TABLE pg_temp.map DISABLE TRIGGER map_filter_insert;
|
|
52 |
\copy pg_temp.map FROM 'map.csv' CSV HEADER;
|
|
53 |
SELECT util.set_col_names_with_metadata('"$table"', 'pg_temp.map'::regclass);
|
|
50 |
SELECT util.reset_map_table('temp.map'); |
|
51 |
ALTER TABLE temp.map DISABLE TRIGGER map_filter_insert; |
|
52 |
\copy temp.map FROM 'map.csv' CSV HEADER; |
|
53 |
SELECT util.set_col_names_with_metadata('"$table"', 'temp.map'::regclass); |
|
54 | 54 |
EOF |
55 | 55 |
} |
56 | 56 |
|
Also available in: Unified diff
lib/runscripts/table.run: map_table(): create the map table as a persistent table in the temp schema, so that its contents can be viewed for debugging