Re: creating a dumpfile from a view

["Taras Kopets" <tkopets(at)gmail(dot)com>]

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