On Mon, Jul 20, 2009 at 3:22 PM, chester c young<chestercyo...@yahoo.com> wrote: > > is there a way for COPY FROM to ignore unused columns in CSV? > > in other words, if table t1 has columns c1, c2, and if csv has columns c1, > c3, c2, could I do something like > > COPY t1( c1, null, c2 ) FROM 'file.csv'
No, but you can use pgloader which can easily deal with your problem and much more. http://pgfoundry.org/projects/pgloader/ -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
