Wim Bertels wrote: > On Wed, 2011-02-02 at 12:49 -0800, Bosco Rama wrote: >> 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 > > Hallo Bosco, > > i tried changing that, but it doesnt seem to work > (the echo only affects the psql cmdl, but is not written to /o file) Apologies, Wim. I meant to also indicate that you need to use the \qecho command. It echoes to the query output stream whereas \echo echoes to the stdout. So you would use: \qecho ECHO queries instead of the \echo above. Hopefully I didn't forget anything else this time. :-) HTH Bosco. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
