Wim Bertels wrote:
>
> --user2
> SET SESSION AUTHORIZATION user2;
> \pset format latex
> \echo ECHO queries
> \o report/test_user2.tex
> \i structure/test_user2.sql
> "
>
> This doenst seem to work,
> as the ECHO queries output isnt written to the file (test_user2.tex)
Actions are performed as they are encountered so put the \echo *after* the
\o, like this:
SET SESSION AUTHORIZATION user2;
\pset format latex
\o report/test_user2.tex
\echo ECHO queries
\i structure/test_user2.sql
HTH,
Bosco.