Re: any psql \copy tricks for default-value columns without source data?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: any psql \copy tricks for default-value columns without source data?
Date: 2014-05-06 20:47:19
Message-ID: 53694A57.2050800@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 5/6/2014 1:22 PM, David G Johnston wrote:
> I know that I can pre-process the input file and simply add the needed data
> but I am curious if maybe there is some trick to having defaults populate
> for missing columns WITHOUT explicitly specifying each and every column that
> is present?

if you didn't specify the columns in your file, how would you expect it
to know whats there and not there?

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2014-05-06 21:04:11 Re: any psql \copy tricks for default-value columns without source data?
Previous Message Ryan Kelly 2014-05-06 20:38:12 Re: any psql \copy tricks for default-value columns without source data?