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
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
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
---