Doug, Robby,
Thanks. That did the trick.
Ken
On Oct 24, 2004, at 8:02 PM, Doug McNaught wrote:
Ken Tozier <[EMAIL PROTECTED]> writes:
I've been looking though the PostgreSQL documentation but can't seem to find a command for importing files. I read the documentation related to large objects but this isn't what I'm looking for as I don't want to import the entire file into a single field, I want to import it as a table. I'm sure there's a way to do it but I can't seem to find the magic command.
Could someone point me to (or provide) an example?
You want the SQL COPY statement, or the \copy command in 'psql'.
-Doug
---------------------------(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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
