unused columns in copy

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: unused columns in copy
Date: 2009-07-20 13:22:49
Message-ID: 471945.42509.qm@web54306.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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'

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Wenk 2009-07-20 13:32:59 Re: Table inheritance problem
Previous Message chester c young 2009-07-20 13:19:39 how to tell if column set on update