On Tue, Aug 26, 2008 at 2:24 PM, <thefronny(at)gmail(dot)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.
In response to
pgsql-general by date
|Next:||From: Scott Marlowe||Date: 2008-08-28 19:09:03|
|Subject: Re: MySQL LAST_INSERT_ID() to Postgres|
|Previous:||From: Pavel Stehule||Date: 2008-08-28 18:40:37|
|Subject: Re: SQL optimization - WHERE SomeField STARTING WITH ...|