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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend