From: soni de <soni.de@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Regarding COPY command from Postgres 8.2.0
Date: Fri, 14 Sep 2007 15:51:51 +0530
Message-ID: <9f2e40a90709140321l11e6cdb5g91d8f8bf0a43fd01@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: soni.de@gmail.com
Subject: Re: Regarding COPY command from Postgres 8.2.0
In-Reply-To: <9f2e40a90709140321l11e6cdb5g91d8f8bf0a43fd01@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox