Reading a text file into PostgreSQL

Started by Eyinagho Newtonover 21 years ago3 messagesgeneral
Jump to latest
#1Eyinagho Newton
neyinagho@yahoo.com

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

#2Steven Klassen
sklassen@commandprompt.com
In reply to: Eyinagho Newton (#1)
Re: Reading a text file into PostgreSQL

* Eyinagho Newton <neyinagho@yahoo.com> [2004-10-07 09:41:47 -0700]:

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

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

#3Ron St-Pierre
rstpierre@syscor.com
In reply to: Eyinagho Newton (#1)
Re: Reading a text file into PostgreSQL

Eyinagho Newton wrote:

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 mean when you read it in using the COPY command, or something
different?

Ron