any psql \copy tricks for default-value columns without source data? - Mailing list pgsql-general

From David G Johnston
Subject any psql \copy tricks for default-value columns without source data?
Date
Msg-id 1399407740815-5802795.post@n5.nabble.com
Whole thread Raw
Responses Re: any psql \copy tricks for default-value columns without source data?  (Ryan Kelly <rpkelly22@gmail.com>)
Re: any psql \copy tricks for default-value columns without source data?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
So, I am trying to import a file into a table and want to assign a sequence
value to each record as it is imported.

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?

Thanks!

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/any-psql-copy-tricks-for-default-value-columns-without-source-data-tp5802795.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: HP-UX 11.23
Next
From: Ryan Kelly
Date:
Subject: Re: any psql \copy tricks for default-value columns without source data?