Home > mailing lists

Re: creating a dumpfile from a view - Mailing list pgsql-general

From	Taras Kopets
Subject	Re: creating a dumpfile from a view
Date	October 30, 2006 20:38:34
Msg-id	[email protected] Whole thread Raw
In response to	creating a dumpfile from a view (Richard Yen <[email protected]>)
Responses	Re: creating a dumpfile from a view
List	pgsql-general

Hi!

Richard Yen wrote:

Would anyone know how to dump the data from the view?

You should check COPY command in the manual: http://www.postgresql.org/docs/current/static/sql-copy.html to save all your data.
But you have to use tables with copy, not views.
Probably the solution will be to store all needed data in temporary table and then use COPY to output data to file.

Try something like this:

CREATE VIEW demtest AS
SELECT foo.serial_no, foo.course_id, foo.writer_id,
foo.assignment_type, bar.critique_serial_no, ...;

CREATE TEMPORARY TABLE temp_demtest AS SELECT * FROM demtest;

COPY temp_demtest TO 'output_file_path';

Taras Kopets

From: Stephan Szabo
Date: 30 October 2006, 20:09:36
Subject: Re: Deleting Problem

From: Reece Hart
Date: 30 October 2006, 20:50:14
Subject: Re: creating a dumpfile from a view