Reading a text file into PostgreSQL

[Eyinagho Newton]

Hiya Everyone,

Can anyone explain how postgreSQL reads from a text
file into tables already created in PostgreSQL?

I am also checking the thread in the Forum just to see
if someone has written about it in the past.

Thanks.

Newton





_______________ _______________ _
Do you Yahoo!?
Declare Yourself - Register online to vote today!

http://vote.yahoo.com

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

[Steven Klassen]

Re: Reading a text file into PostgreSQL

* Eyinagho Newton <neyinagho@yaho o.com> [2004-10-07 09:41:47 -0700]:
[color=blue]
> Can anyone explain how postgreSQL reads from a text file into tables
> already created in PostgreSQL?[/color]

Where did this text file come from? What format is it in?

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postg resql.org

[Ron St-Pierre]

Re: Reading a text file into PostgreSQL

Eyinagho Newton wrote:
[color=blue]
>Hiya Everyone,
>
>Can anyone explain how postgreSQL reads from a text
>file into tables already created in PostgreSQL?
>
>I am also checking the thread in the Forum just to see
>if someone has written about it in the past.
>
>Thanks.
>
>Newton
>
>[/color]
Do you mean when you read it in using the COPY command, or something
different?

Ron


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)