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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pdxpug by date

  From Date Subject
Next Message Brent Dombrowski 2011-02-03 16:56:04 Re: Newlines in pg_dump output?
Previous Message Rich Shepard 2011-02-03 16:52:26 Newlines in pg_dump output?