On Sat, 08 Nov 2008 13:05:08 +1300 "Brent Wood" <b.wood@xxxxxxxxxx> wrote: > Thanks guys, > > I'm aware of those options, what I was wondering was if there is a > more generic way, for example the Empress RDBMS allows 'set > MSNULLVALUE "NA"', and all NULLs will from then on be output as NA. > > The COPY option is closest to a generic setting, but doesn't work > with a select query, just a table dump. \copy (select ....) to ... works. As written in my 2nd post. -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general