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.g.johns...@gmail.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. >