I guess this is a feature request since I can't figure
out a way to do it directly in postgresql (plus
COPY/\copy isn't in SQL specs). Often when I import
data I need to assign foreign key id's, timestamps,
etc. How about a syntax something like:
\copy tablename (col1, col2, col3, fkid=8,
CSN [EMAIL PROTECTED] writes:
I guess this is a feature request since I can't figure
out a way to do it directly in postgresql (plus
COPY/\copy isn't in SQL specs).
You do know that COPY uses the column defaults for all columns not
listed in the input list?
regards,
--- Tom Lane [EMAIL PROTECTED] wrote:
CSN [EMAIL PROTECTED] writes:
I guess this is a feature request since I can't
figure
out a way to do it directly in postgresql (plus
COPY/\copy isn't in SQL specs).
You do know that COPY uses the column defaults for
all columns not
listed in the