Re: Running a void function in psql - Mailing list pgsql-general

From Tom Lane
Subject Re: Running a void function in psql
Date
Msg-id 5157.1105486377@sss.pgh.pa.us
Whole thread Raw
In response to Running a void function in psql  (Eric Brown <eric.brown@propel.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: int4 -> unix timestamp -> sql timestamp; abstime?
Next
From: Tom Lane
Date:
Subject: Re: int4 -> unix timestamp -> sql timestamp; abstime?