Re: [GENERAL] export from views

2006-04-14 Thread John DeSoi
On Apr 13, 2006, at 10:58 AM, Tomas Lanczos wrote: I am quite a newbie in the database business, so sorry for stupid questions. Is there any convenient and simple method/tool to export data from views to file, something like COPY TO (file) from a table? One option is to create a temp tab

Re: [GENERAL] export from views

2006-04-13 Thread Michael Glaesemann
On Apr 13, 2006, at 23:58 , Tomas Lanczos wrote: Is there any convenient and simple method/tool to export data from views to file, something like COPY TO (file) from a table? In psql, take a look at \o (and \? while you're at it). Hope this helps. Michael Glaesemann grzm myrealbox com

[GENERAL] export from views

2006-04-13 Thread Tomas Lanczos
Hello everybody, I am quite a newbie in the database business, so sorry for stupid questions. Is there any convenient and simple method/tool to export data from views to file, something like COPY TO (file) from a table? I am using WinXP and Postgresql 8.1. Many thanks in advance Tomas ---