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

Date Format Question

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Date Format Question
Date: 2011-02-03 16:14:43
Message-ID: alpine.LNX.2.00.1102030810020.25032@salmo.appl-ecosys.com (view raw or flat)
Thread:
Lists: pdxpug
   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.

TIA,

Rich

Responses

pdxpug by date

Next:From: Rich ShepardDate: 2011-02-03 16:52:26
Subject: Newlines in pg_dump output?
Previous:From: Rich ShepardDate: 2011-02-02 19:44:28
Subject: Re: COPY command syntax error [SOLVED]

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