Skip site navigation (1) Skip section navigation (2)

Re: Date Format Question

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pdxpug(at)postgresql(dot)org
Subject: Re: Date Format Question
Date: 2011-02-03 16:55:38
Message-ID: 2D71CEC8-D3A6-49CD-82F8-060AF8521AFD@kineticode.com (view raw or flat)
Thread:
Lists: pdxpug
On Feb 3, 2011, at 8:14 AM, Rich Shepard wrote:

>  One column in a table has the data type DATE. Do I need to wrap the date
> in single quotes in the .csv file before importing those rows into the
> table? Dates in the table are not quoted.

Not if you're using COPY, no. To see what format you need in the CSV, try creating a few rows and then exporting them

  COPY mytable TO STDOUT CSV;

Best,

David


In response to

Responses

pdxpug by date

Next:From: Brent DombrowskiDate: 2011-02-03 16:56:04
Subject: Re: Newlines in pg_dump output?
Previous:From: Rich ShepardDate: 2011-02-03 16:52:26
Subject: Newlines in pg_dump output?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group