SEO

#1 (**permalink**) 04-09-2008, 09:17 AM

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#2 (**permalink**) 04-09-2008, 09:17 AM

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#3 (**permalink**) 04-09-2008, 09:18 AM

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

export from views