On Tue, Jun 20, 2006 at 10:29:21AM -0700, Aaron Koning wrote: > CREATE TABLE sometable AS SELECT * FROM someview; > pg_dump -t sometable dbname > DROP TABLE sometable > > Que? Si! Eh? If you're going to create the table anyway, I'd use psql: psql -c "COPY table TO STDOUT" If you put "CSV" there you can get the output in CSV. Far cleaner than pg_dump. -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
