copyable, importable... into Excel or another postgres db?
On 6/20/06, Martijn van Oosterhout <kleptog@svana.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@svana.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/+--------------------------------------------