Search Postgresql Archives

Re: Improvement for COPY command .. unless it already exists (If yes please tell me!)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: David Gagnon <dgagnon@xxxxxxxxxx>
Subject: Re: Improvement for COPY command .. unless it already exists (If yes please tell me!)
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Thu, 07 Apr 2005 10:15:33 -0400
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to David Gagnon <dgagnon@siunik.com> message dated "Thu, 07 Apr 2005 08:20:12 -0400"
In-reply-to: <4255257C.9020004@siunik.com>
References: <42545EB6.6070304@siunik.com> <1112827242.1387.14.camel@Andrea.peacock.de> <4255257C.9020004@siunik.com>
Sender: pgsql-general-owner@xxxxxxxxxxxxxx

David Gagnon <dgagnon@xxxxxxxxxx> writes:
> Is there a way to specify default values in the COPY command?

There's always ALTER TABLE ... SET DEFAULT.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Improvement for COPY command .. unless it already exists
  - From: David Gagnon

References:
- COPY command use UTF-8 encoding and NOT UNICODE(16bits)... please confirm. Should postgresql add :set CLIENT_ENCODING to 'UTF-8'; to avoid confusion
  - From: David Gagnon
- Re: COPY command use UTF-8 encoding and NOT
  - From: Tino Wildenhain
- Improvement for COPY command .. unless it already exists (If yes please tell me!)
  - From: David Gagnon

Prev by Date: Re: lower function
Next by Date: Re: Improvement for COPY command .. unless it already exists
Previous by thread: Improvement for COPY command .. unless it already exists (If yes please tell me!)
Next by thread: Re: Improvement for COPY command .. unless it already exists
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]