Re: loading delimited files

From: Antti Haapala <antti(dot)haapala(at)iki(dot)fi>
To: will trillich <will(at)serensoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: loading delimited files
Date: 2003-01-22 06:00:36
Message-ID: Pine.GSO.4.44.0301220754420.21186-100000@paju.oulu.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> > Are there docs on how to load delimited files into the database?
>
> to see the format. note that ALL fields in the table are
> exported, and should be included on the import, as well (in
> field-definition order, from your create statements).

And again, if using Pg 7.3 you are not even bound to original column
ordering, or are obliged to copy all the columns.

Also check psql command \copy, it's more often the one you need.

--
Antti Haapala
+358 50 369 3535
ICQ: #177673735

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Gibbs 2003-01-22 06:11:41 Re: repost of how to do select in a constraint
Previous Message Tom Lane 2003-01-22 05:56:06 Re: Error at end of pg_dump output (setting sequence number?)