Re: Exporting data from view
| От | Aaron Koning |
|---|---|
| Тема | Re: Exporting data from view |
| Дата | |
| Msg-id | 1319fbba0606201029s39f1778fid8d1ccc0e6ccd253@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Exporting data from view ("Worky Workerson" <worky.workerson@gmail.com>) |
| Ответы |
Re: Exporting data from view
|
| Список | pgsql-general |
CREATE TABLE sometable AS SELECT * FROM someview;
pg_dump -t sometable dbname
DROP TABLE sometable
Que? Si!
--
+--------------------------------------------
| Aaron Koning
| Information Technologist
| Prince George, BC, Canada.
+--------------------------------------------
| http://datashare.gis.unbc.ca/fist/
| http://datashare.gis.unbc.ca/gctp-js/
+--------------------------------------------
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/
+--------------------------------------------
В списке pgsql-general по дате отправления: