Re: COPY, \copy with defaults

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: CSN <cool_screen_name90001(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY, \copy with defaults
Date: 2004-08-09 04:55:08
Message-ID: 5669.1092027308@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

CSN <cool_screen_name90001(at)yahoo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message CSN 2004-08-09 05:00:18 Re: COPY, \copy with defaults
Previous Message CSN 2004-08-09 04:37:03 PostgreSQL 8.0 Feature List?