| From: | Robby Russell <robby(at)planetargon(dot)com> |
|---|---|
| To: | Ken Tozier <kentozier(at)comcast(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Importing a tab delimited text file - How? |
| Date: | 2004-10-24 23:57:33 |
| Message-ID: | 1098662253.4524.29.camel@vacant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)planetargon(dot)com
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
****************************************/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2004-10-25 00:02:45 | Re: Importing a tab delimited text file - How? |
| Previous Message | Tom Lane | 2004-10-24 23:53:58 | Re: PostgreSQL Security Release(s) for 7.2, 7.3 and 7.4 |