Scott Marlowe wrote:
> On Nov 21, 2007 10:49 AM, Richard Huxton <dev@archonet.com> wrote:
>> 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
youwant 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>
>
> And from the more than one way to skin a cat department:
>
> cat my.sql | psql mydb
> psql mydb < my.sql
Bearing in mind that although both mine and Scott's cats are skinless,
mine gave me line numbers in error messages.
--
Richard Huxton
Archonet Ltd