Re: loading delimited files - Mailing list pgsql-general

From dev@archonet.com
Subject Re: loading delimited files
Date
Msg-id 3264.192.168.1.16.1042486381.squirrel@mainbox.archonet.com
Whole thread Raw
In response to loading delimited files  ("Campano, Troy" <Troy.Campano@LibertyMutual.com>)
List pgsql-general
> Are there docs on how to load delimited files into the database?

Look into the SQL reference for the "COPY" command or the \copy option in
the psql man page.

One thing to look out for is whether the file is readable by the
front/backend depending on which method you use.

If your data needs some massaging then, as always, perl is your friend.

- Richard Huxton

pgsql-general by date:

Previous
From: "Pirtea Calin Iancu"
Date:
Subject: Re: Re PostgreSQL on Windows
Next
From: Tom Lane
Date:
Subject: Re: clarifying a few error messages