Gauthier, Dave wrote:
> APparently, from "man psql", -c can do only one thing at a time. But you could do this with 2-3 commands (or 1 if you want to wrap the 2 up in a shell script or something). Here's an example...
[snip]
> psql --dbname mydb -c "\i create_try.sql;"
> psql --dbname mydb -c "select trythis('foo');"
> psql --dbname mydb -c "drop function trythis(varchar);"
Or just put everything in one file and use -f <filename>
--
Richard Huxton
Archonet Ltd