Re: Exporting data from view

CREATE TABLE sometable AS SELECT * FROM someview;
pg_dump -t sometable dbname
DROP TABLE sometable

Que? Si!

On 6/20/06, Worky Workerson <worky(dot)workerson(at)gmail(dot)com> wrote:
>
> On 6/20/06, Aaron Koning <aaronkoning(at)gmail(dot)com> wrote:
> > google pg_dump
>
> Really? What command do you use? I've tried the following:
>
> pg_dump -t viewname dbname
>
> and I get the view definition, whereas I would like the data. Is
> there an option to pg_dump that I'm missing?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
+--------------------------------------------
| Aaron Koning
| Information Technologist
| Prince George, BC, Canada.
+--------------------------------------------
| http://datashare.gis.unbc.ca/fist/
| http://datashare.gis.unbc.ca/gctp-js/
+--------------------------------------------