Re: Importing a tab delimited text file - How?

Doug, Robby,

Thanks. That did the trick.

Ken

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

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