CREATE TABLE sometable AS SELECT * FROM someview;
pg_dump -t sometable dbname
DROP TABLE sometable
Que? Si!
On 6/20/06, Worky Workerson <worky.workerson@gmail.com> wrote: On 6/20/06, Aaron Koning <aaronkoning@gmail.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@postgresql.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/+--------------------------------------------