Thread: export from views

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

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

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 table and then use COPY on the temp
table. Something like

CREATE TEMP TABLE temp_table AS SELECT * from some_view;


It would be really nice if copy worked on views directly.




John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL