From: | "Aaron Koning" <aaronkoning(at)gmail(dot)com> |
---|---|
To: | "Worky Workerson" <worky(dot)workerson(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Exporting data from view |
Date: | 2006-06-20 17:06:25 |
Message-ID: | 1319fbba0606201006k6ff18d19sf036174e7ee9b8e6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
google pg_dump
On 6/20/06, Worky Workerson <worky(dot)workerson(at)gmail(dot)com> wrote:
>
> I read recently about the efforts underway to COPY from a view,
> however I was wondering what the current best-practices are for being
> able to copy out of a view and import that data into an actual table
> elsewhere. I am currently doing psql -c "SELECT ..." and the using a
> bit of perl to transform that into something copyable (i.e. CSV), but
> is there a way to directly export the data in an easily importable
> form?
>
> Thanks!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
+--------------------------------------------
| Aaron Koning
| Information Technologist
| Prince George, BC, Canada.
+--------------------------------------------
| http://datashare.gis.unbc.ca/fist/
| http://datashare.gis.unbc.ca/gctp-js/
+--------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | A.M. | 2006-06-20 17:10:40 | Re: [INTERFACES] help with error message from perl Pg |
Previous Message | Michael Fuhr | 2006-06-20 16:58:10 | Re: Help requd in writing functions in C and using in Postgres |