Home > mailing lists

COPY with FORMAT in Postgresql 9.x - Mailing list pgsql-sql

From	Humair Mohammed
Subject	COPY with FORMAT in Postgresql 9.x
Date	December 3, 2010 05:13:48
Msg-id	COL115-W14A2507415BEDD0DE5BB1BA8270@phx.gbl Whole thread Raw
Responses	Re: COPY with FORMAT in Postgresql 9.x
List	pgsql-sql

Postgres 9.x provies the COPY command with new syntax with a new option called FORMAT

However when I run the following command:

COPY dQstn FROM 'c:/bcp/postgres/dQstn.csv' WITH FORMAT csv;

I get the following error message:

ERROR: syntax error at or near "FORMAT"

If I use the 8.x syntax without the FORMAT option it works fine.

From: Dimitri
Date: 02 December 2010, 20:46:53
Subject: Calculate next event date based on instance of the day of week

From: Jayadevan M
Date: 03 December 2010, 05:19:33
Subject: Re: Calculate next event date based on instance of the day of week