Re: loading delimited files

From: dev(at)archonet(dot)com
To: "Campano, Troy" <Troy(dot)Campano(at)LibertyMutual(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: loading delimited files
Date: 2003-01-13 19:33:01
Message-ID: 3264.192.168.1.16.1042486381.squirrel@mainbox.archonet.com
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?

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-13 20:03:51 Re: clarifying a few error messages
Previous Message Pirtea Calin Iancu 2003-01-13 19:09:26 Re: Re PostgreSQL on Windows