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

From Doug McNaught
Subject Re: Importing a tab delimited text file - How?
Date
Msg-id 877jpfmzq2.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Importing a tab delimited text file - How?  (Ken Tozier <kentozier@comcast.net>)
Responses Re: Importing a tab delimited text file - How?
List pgsql-general
Ken Tozier <kentozier@comcast.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

pgsql-general by date:

Previous
From: Robby Russell
Date:
Subject: Re: Importing a tab delimited text file - How?
Next
From: Karim Nassar
Date:
Subject: Re: Duplicating a database