We are loading a whole database using multiple copy command from inside a sql
script. Here is a couple of sample lines:
COPY choice FROM '/esc/pgrnd/prog/choice/choice.d.txt' DELIMITERS '|' WITH
NULL AS '?'; \i choice/choicePostLoad.sql;
COPY glacct FROM '/esc/pgrnd/prog/glacct/glacct.d.txt' DE
Hi,
I am trying to import data using COPY, from a file containing thirty or
so COPY commands each with 0 or more rows of data. Reason, I have a
small data set I want to include into a database with an identical
schema, with existing data. I figured a good way to do this would be to
use pg_dum
