Re: Access to postgres conversion
| От | akp geek |
|---|---|
| Тема | Re: Access to postgres conversion |
| Дата | |
| Msg-id | BANLkTi=UKD0tG7B2BvU07r5tAYU4cSH3hQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Access to postgres conversion (Vick Khera <vivek@khera.org>) |
| Список | pgsql-general |
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@khera.org> wrote:
On Thu, Jun 2, 2011 at 10:01 AM, akp geek <akpgeek@gmail.com> wrote:Export to CSV or tab delimited file, then suck it in with a COPY
> 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.
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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: