Re: Importing a tab delimited text file - How? - Mailing list pgsql-general

From Robby Russell
Subject Re: Importing a tab delimited text file - How?
Date
Msg-id 1098662253.4524.29.camel@vacant
Whole thread Raw
In response to Importing a tab delimited text file - How?  (Ken Tozier <kentozier@comcast.net>)
List pgsql-general
On Sun, 2004-10-24 at 19:25 -0400, Ken Tozier wrote:
> I've been looking though the PostgreSQL documentation but can't seem to
> find a command for importing files. I read the documentation related to
> large objects but this isn't what I'm looking for as I don't want to
> import the entire file into a single field, I want to import it as a
> table. I'm sure there's a way to do it but I can't seem to find the
> magic command.
>
> Could someone point me to (or provide) an example?
>
> Thanks,
>

\h COPY

The COPY command will help you with this.

-Robby


--
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON  | www.planetargon.com
* Portland, OR  | robby@planetargon.com
* 503.351.4730  | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
****************************************/


Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL Security Release(s) for 7.2, 7.3 and 7.4
Next
From: Doug McNaught
Date:
Subject: Re: Importing a tab delimited text file - How?