Thread: Reading from a text file into PostgreSQL

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

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/

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.