Re: How to echo statements in sourced file?

Thank you all. From your replies I was able to figure out what I needed:
"\set ECHO queries"
Kynn

On Wed, Dec 3, 2008 at 7:14 PM, Kynn Jones <kynnjo(at)gmail(dot)com> wrote:

> Hi. I have a collection of SQL statements stored in a file that I run
> periodically via cron. Running this "script" takes a bit too long, even for
> a cron job, and I would like to profile it.
> I learned from Andreas Kretschmer (in another thread, in the
> pgsql-performance list) about the \timing directive, which is useful for
> this.
>
> Now, after turning timing on, when I "source" the script from within psql,
> with
>
> mydb=> \i /path/to/my/script
>
> ...I get output lines like this
>
> Time: 38.519 ms
>
> right in my psql terminal after each statement in the file gets executed.
>
> But now I need a way to have these statements that are being timed
> themselves echoed to the terminal. Is there a way to do this?
>
> TIA!
>
> Kynn
>
>