

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

Thu, 7 Oct 2004 07:45:29 -0700 (PDT)
Eyinagho Newton <neyinagho@yahoo.com>
Reading from a text file into PostgreSQL
Eyinagho Newton wrote:
> Can anyone explain how postgreSQL reads from a text
> file into tables already created in PostgreSQL?

Please direct general usage questions to <pgsql-general@postgresql.org>.

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

Please do that before posting.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


Thu, 7 Oct 2004 16:50:05 +0200
Peter Eisentraut <peter_e@gmx.net>
Re: Reading from a text file into PostgreSQL
On Thu, 7 Oct 2004, Eyinagho Newton wrote:
> Can anyone explain how postgreSQL reads from a text
> file into tables already created in PostgreSQL?

Check out COPY command.

http://www.postgresql.org/docs/7.4/interactive/sql-copy.html

The file has to be in a certain format as explained in the
documentaion. It is fast and simple.



Thu, 7 Oct 2004 11:43:38 -0400 (EDT)
Chester Kustarz <chester@arbor.net>
Re: Reading from a text file into PostgreSQL