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

From Ken Tozier
Subject Re: Importing a tab delimited text file - How?
Date
Msg-id 7A0ECFC2-2622-11D9-87A4-003065F300E2@comcast.net
Whole thread Raw
In response to Re: Importing a tab delimited text file - How?  (Doug McNaught <doug@mcnaught.org>)
Responses Complex query need help with OR condition.  (Ken Tozier <kentozier@comcast.net>)
List pgsql-general
Doug, Robby,

Thanks. That did the trick.

Ken


On Oct 24, 2004, at 8:02 PM, Doug McNaught wrote:

> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if
> your
>       joining column's datatypes do not match
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Memory exhausted on DELETE.
Next
From: "Chris"
Date:
Subject: partial index on a text field