Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY, \copy with defaults - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY, \copy with defaults
Date
Msg-id 5669.1092027308@sss.pgh.pa.us
Whole thread Raw
In response to COPY, \copy with defaults  (CSN <cool_screen_name90001@yahoo.com>)
Responses Re: COPY, \copy with defaults  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: CSN
Date:
Subject: PostgreSQL 8.0 Feature List?
Next
From: CSN
Date:
Subject: Re: COPY, \copy with defaults