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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general