psql command line question.. - Mailing list pgsql-general

From Williams, Travis L, NPONS
Subject psql command line question..
Date
Msg-id AB815D267EC31A4693CC24D234F8291603777211@ACCLUST02EVS1.ugd.att.com
Whole thread Raw
Responses Re: psql command line question..
List pgsql-general
I have a bunch of huge inserts in a flat file.  They are in proper sql context and I can take each individual and
copy/pasteit into psql and it inserts fine.  I tried doing a psql -e dbname < file.sql and I get errors.  Is there
anythingspecific I need to do to the file format?  Each query is on its own new line.  I didn't know if I should add a
semicolonto the end so I did just to check it.. but it doesn't seem to make a difference.  I tried doing this through
DBD::Pgbut it seems to complain about an extra apostrophe that doesn't exist (which psql did until I quite quoting my
numerics). I noticed in Bruces readme that it said that psql would do this sometimes if you have to many apostrophes..
doesthis also affect DBD::Pg? 


Travis

pgsql-general by date:

Previous
From: andy@mixonic.com (Andy)
Date:
Subject: need much better query perfomance
Next
From: Bruce Momjian
Date:
Subject: Upcoming events