Re: Access to postgres conversion

The only problem I am seeing with dates as you mentioned. when I export the
data to csv the date is getting the format of 8/1/1955 0:00:00 , but
postgres not accepting that. Any clues?

Regards

On Thu, Jun 2, 2011 at 11:23 AM, Vick Khera <vivek(at)khera(dot)org> wrote:

> On Thu, Jun 2, 2011 at 10:01 AM, akp geek <akpgeek(at)gmail(dot)com> wrote:
> > Thanks so much . I was using bullzip What I felt with Bullzip was it is
> good
> > for less amount of data. I have 2 tables each of which has 2.5 million
> > records. For me it is taking for ever, The job that I set up has been
> > running since 12 hours.
>
> Export to CSV or tab delimited file, then suck it in with a COPY
> statement in postgres. Just make sure that there is no "invalid" data
> like fake dates. 2.5 million rows should take a couple of minutes
> tops to insert into a modern hardware server.
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>