From: | "Tomi NA" <hefest(at)gmail(dot)com> |
---|---|
To: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
Cc: | "Alban Hertroys" <alban(at)magproductions(dot)nl>, "Antonios Katsikadamos *EXTERN*" <antonioskatsikadamos(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgres import |
Date: | 2006-11-02 15:44:20 |
Message-ID: | d487eb8e0611020744l1650d804o330b09a169fdc5c7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2006/11/2, Albe Laurenz <all(at)adv(dot)magwien(dot)gv(dot)at>:
> >>>> psql -h host -p port -d database -U user <dump.sql
> >>>
> >>> It's a good enough solution in most cases, but when the rowcount
> >>> starts to skyrocket, it simply doesn't seem to cut it (at least I
> >>> couldn't make it to).
> >>
> >> INSERT statements? You dumped with the -d flag, didn't you?
> >
> > No I didn't, actually. :) The data was never in the database in the
> > first place: it was generated from a different source. True, it was
> > generated as a CSV file which I converted into INSERT statements, but
> > conversion between the two is not a problem (given 1.5GB of RAM).
>
> Then the best way is to convert it back to a CSV and use the COPY
> statement to load in into the table (or \copy from psql).
> You don't need any third party tools for that, it's all in PostgreSQL.
I had a problem with copy, but I can't remember what exactly...come to
think of it, it could have probably done the job...assuming I define
the primary key as DEFAULT nextval('id'), as I had no id in the rows I
was importing...nice to have alternatives. Thanks for the suggestion.
t.n.a.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-11-02 15:45:18 | Re: Availability of pg_backend_pid() immediately after connection establishment |
Previous Message | Sandeep Kumar Jakkaraju | 2006-11-02 15:41:58 | Re: PostGIS |