From: Ansgar -59cobalt- Wiechers <lists@planetcobalt.net>
To: pgsql-performance@postgresql.org
Subject: Re: Regarding COPY command from Postgres 8.2.0
Date: Fri, 14 Sep 2007 14:03:21 +0200
Message-ID: <20070914120321.GA2615@mail.planetcobalt.net> (raw)
In-Reply-To: <9f2e40a90709140321l11e6cdb5g91d8f8bf0a43fd01@mail.gmail.com>
References: <9f2e40a90709140321l11e6cdb5g91d8f8bf0a43fd01@mail.gmail.com>
On 2007-09-14 soni de wrote:
> 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?
I don't know if it is possible, but even if it were I'd strongly
recommend against it, as you'd be relying on the order the columns were
created in. That's a rather bad idea IMHO. Why would you want to avoid
giving the names of the columns in the first place?
Regards
Ansgar Wiechers
--
"The Mac OS X kernel should never panic because, when it does, it
seriously inconveniences the user."
--http://developer.apple.com/technotes/tn2004/tn2118.html
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: lists@planetcobalt.net
Subject: Re: Regarding COPY command from Postgres 8.2.0
In-Reply-To: <20070914120321.GA2615@mail.planetcobalt.net>
* 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