Re: Importing a tab delimited text file - How?

From: Doug McNaught <doug(at)mcnaught(dot)org>
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-25 00:02:45
Message-ID: 877jpfmzq2.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ken Tozier <kentozier(at)comcast(dot)net> writes:

> 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?

You want the SQL COPY statement, or the \copy command in 'psql'.

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-10-25 00:56:31 Re: Function syntax checking
Previous Message Robby Russell 2004-10-24 23:57:33 Re: Importing a tab delimited text file - How?