On Nov 21, 2007 11:16 AM, Richard Huxton <dev@archonet.com> wrote:
>
> 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
ifyou 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>
> >
> > 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.
So do both of mine... In fact, trying all four ways (\i, cat | psql,
psql < file.sql, and psql -f file) gave me the same error output.