Re: [GENERAL] Reading a text file into PostgreSQL

2004-10-07 Thread Ron St-Pierre 
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
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] Reading a text file into PostgreSQL

2004-10-07 Thread Steven Klassen 
* Eyinagho Newton <[EMAIL PROTECTED]> [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

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Reading a text file into PostgreSQL

2004-10-07 Thread 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