Re: loading delimited files - Mailing list pgsql-general

From Antti Haapala
Subject Re: loading delimited files
Date
Msg-id Pine.GSO.4.44.0301220754420.21186-100000@paju.oulu.fi
Whole thread Raw
In response to Re: loading delimited files  (will trillich <will@serensoft.com>)
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error at end of pg_dump output (setting sequence number?)
Next
From: "Qiao Jian ( Net2Room)"
Date:
Subject: Re: FW: ERROR: Relation "pg_user" does not exist