Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 609E49F9B04
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 14 Sep 2007 07:21:57 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 82523-02-2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 14 Sep 2007 07:21:53 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from wa-out-1112.google.com (wa-out-1112.google.com
 [209.85.146.181])
	by postgresql.org (Postfix) with ESMTP id 4B6B39FA265
	for <pgsql-performance@postgresql.org>;
	Fri, 14 Sep 2007 07:21:53 -0300 (ADT)
Received: by wa-out-1112.google.com with SMTP id m38so1036989waf
	for <pgsql-performance@postgresql.org>;
	Fri, 14 Sep 2007 03:21:51 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=TqM3olL0YwZMWOPKLij7unzAaBjxx3GLS9JV4Luo1lc=;
	b=U9I9d+0nlrQI+5v05plimjCKSSwLZV9qh2rTYbur3OxZRgUehZpu8rqPi13NzipmlmLr4Sdh7TjE0EmOcX+LIfu8rRR5D/AqnQZLQKiU7n9Houm3W1T70YlT12aCrKoZsaEkdIVp+2jWLWzDT+l0zJLKC3u66Y3zWW5W26amrA4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=sGCaRxDynlYm2mzkcoqce+EMfjsahDXu099Dka6ufLWVwp4yxUHwBLNjB62Mf2/IYneGqUjfEOWRUOtYszoIAzSZP+9zYCmvsjJJ1fVOtQdH1qhZK2/nMEN+pszyPGSIdsM2/ah/fc30c7j5vR7ar9o04BFgOI3kdSBHdwA66oY=
Received: by 10.114.12.9 with SMTP id 9mr1527833wal.1189765311680;
	Fri, 14 Sep 2007 03:21:51 -0700 (PDT)
Received: by 10.114.123.13 with HTTP; Fri, 14 Sep 2007 03:21:51 -0700 (PDT)
Message-ID: <9f2e40a90709140321l11e6cdb5g91d8f8bf0a43fd01@mail.gmail.com>
Date: Fri, 14 Sep 2007 15:51:51 +0530
From: "soni de" <soni.de@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Regarding COPY command from Postgres 8.2.0
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2683_14016725.1189765311672"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200709/272
X-Sequence-Number: 26817

------=_Part_2683_14016725.1189765311672
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_2683_14016725.1189765311672
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hello,</div>
<div>&nbsp;</div>
<div>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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 
</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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.
</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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?</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Please provide us some help regarding above query.</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks,</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Soni</span></p>
<p class="MsoNormal" style="MARGIN: 0in 0in 0pt"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">&nbsp;</span></p></div>

------=_Part_2683_14016725.1189765311672--