Running a void function in psql
I run 'psql -f mycreatedb.sql' to setup things for my program.
It has to run a few stored procedures after they're created. However, I
do this by 'SELECT f(...);'. When I do this though, it prints out a
bunch of rubbish like:
f
------
(1 row)
How do I get rid of this rubbish? I just want to see errors or
NOTICE/INFO strings I intentionally log.
Thanks.
Eric Brown
408-571-6341
www.propel.com
Eric Brown <eric.brown@propel.com> writes:
I run 'psql -f mycreatedb.sql' to setup things for my program.
It has to run a few stored procedures after they're created. However, I
do this by 'SELECT f(...);'. When I do this though, it prints out a
bunch of rubbish like:
f
------
(1 row)
How do I get rid of this rubbish? I just want to see errors or
NOTICE/INFO strings I intentionally log.
Something like
SELECT f(...)
\g /dev/null
should do it.
regards, tom lane