Postgres Pro
Downloads
Home   >   mailing lists

Re: importing dates - Mailing list pgsql-general

From Scott Marlowe
Subject Re: importing dates
Date
Msg-id dcc563d10808281206g1c47fab8kb712cc82b53a1bc6@mail.gmail.com
Whole thread Raw
In response to importing dates  (thefronny@gmail.com)
List pgsql-general
Tree view 
On Tue, Aug 26, 2008 at 2:24 PM,  <thefronny@gmail.com> wrote:
> I need to copy some data that includes an date as YYYY/MM/DD. Is there
> a method I can do this and replace the "/" with "-" on the fly in the
> copy command string?

You shouldn't need to.  Pgsql should accept yyyy/mm/dd as valid date
format and load it right in.

pgsql-general by date:

Previous
From: "Masis, Alexander \(US SSA\)"
Date:
Subject: MySQL LAST_INSERT_ID() to Postgres
Next
From: "Scott Marlowe"
Date:
Subject: Re: MySQL LAST_INSERT_ID() to Postgres