Re: Exporting data from view

copyable, importable... into Excel or another postgres db?

On 6/20/06, Martijn van Oosterhout <kleptog(at)svana(dot)org> wrote:
>
> On Tue, Jun 20, 2006 at 10:29:21AM -0700, Aaron Koning wrote:
> > CREATE TABLE sometable AS SELECT * FROM someview;
> > pg_dump -t sometable dbname
> > DROP TABLE sometable
> >
> > Que? Si!
>
> Eh? If you're going to create the table anyway, I'd use psql:
>
> psql -c "COPY table TO STDOUT"
>
> If you put "CSV" there you can get the output in CSV. Far cleaner than
> pg_dump.
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> > From each according to his ability. To each according to his ability to
> litigate.
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (GNU/Linux)
>
> iD8DBQFEmE9VIB7bNG8LQkwRAhJTAJ9loGC2v/inI+28RLvbRGGAljS6/ACdEJDn
> e/aJg1Qu6XaBNIuhiPWt+MU=
> =rpRd
> -----END PGP SIGNATURE-----
>
>
>

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