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

Hey,
you may want to have a look at pg_bulkload (
http://pgbulkload.projects.pgfoundry.org/).
Using filter you could get the function you want.

Another solution is pgloader (http://pgloader.tapoueh.org) , but I don't
know if it is as fast as copy.

Cheers,
Rémi-C

2014-05-06 23:04 GMT+02:00 David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>:

> On Tue, May 6, 2014 at 4:48 PM, John R Pierce [via PostgreSQL] <[hidden
> email] <http://user/SendEmail.jtp?type=node&node=5802804&i=0>> wrote:
>
>> 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?
>>
>>
> ​The default copy behavior is column-order dependent. If your input file
> has 10 columns and the table has 10 columns they get matched up 1-to-1 and
> everything works just fine. It would be nice if there was some way to say
> that if the table has 12 columns but the file has 10 columns that the first
> 10 columns of the table get matched to the file and the remaining two
> columns use their default values; that way you can add default columns to
> the end of the table and still do an auto-matching import.
>
> David J.
> ​
>
> ------------------------------
> View this message in context: Re: any psql \copy tricks for default-value
> columns without source data?<http://postgresql.1045698.n5.nabble.com/any-psql-copy-tricks-for-default-value-columns-without-source-data-tp5802795p5802804.html>
>
> Sent from the PostgreSQL - general mailing list archive<http://postgresql.1045698.n5.nabble.com/PostgreSQL-general-f1843780.html>at Nabble.com.
>