Running a void function in psql

Started by Eric Brownover 21 years ago2 messagesgeneral
Jump to latest
#1Eric Brown
eric.brown@propel.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Eric Brown (#1)
Re: Running a void function in psql

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