By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,177 Members | 976 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,177 IT Pros & Developers. It's quick & easy.

Reading a text file into PostgreSQL

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
* Eyinagho Newton <ne*******@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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #2

P: n/a
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 ma*******@postgresql.org)

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.