Re: loading a funtion script from a file - Mailing list pgsql-general

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