Regarding COPY command from Postgres 8.2.0

From: "soni de" <soni(dot)de(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Regarding COPY command from Postgres 8.2.0
Date: 2007-09-14 10:21:51
Message-ID: 9f2e40a90709140321l11e6cdb5g91d8f8bf0a43fd01@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

In Postgres 7.2.4, COPY command is working fine even if tables have 6 fields
but we are copying only 5 fields from the file

But in Postgres 8.2.0, if table has 6 fields and we need to copy data for 5
fields only, then we need to specify the column names too in COPY command.

Is there any configurable option, so that without specifying column name in
COPY command we can copy records in table as happened in Postgres 7.2.4?

Please provide us some help regarding above query.

Thanks,

Soni

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message db 2007-09-14 11:31:45 Re: Long Running Commits - Not Checkpoints
Previous Message Philippe Amelant 2007-09-14 08:34:13 Re: Index files