Thread: COPY, \copy with defaults

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,
ts1='2004-8-8') from 'data.csv'

or maybe add a defaults clause after "with":

\copy tablename (col1, col2, col3) from 'data.csv'
with defaults (fkid=8,ts1='2004-8-8')

Or if anybody knows of a better/existing way please
feel free. :)

CSN

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

CSN <cool_screen_name90001@yahoo.com> 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

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:

> CSN <cool_screen_name90001@yahoo.com> 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?

Yep, but that won't work (foreign key id's, timestamps
other than now(), ...)

CSN



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com