Thread: Importing data
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I have an old-ish Sybase dbms (SQL Anywhere v5.x) that does not offer a DUMP command. The only way to extract data is to SELECT all of it, then OUTPUT it in some format: csv, dbase2, dbase3, etc. I searched the docs and faqs for information on importing data and could not find anything about importing data. I am (still) using os/2 so most (all?) of the GUI options are not available to me. :-\ postgresql v7.3.2 - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/PBb8sxxMki0foKoRAqepAJ9cf0DNPWpG4xakUbvdWEAfoDmpXwCgpLsT Uh1o9kmKfYm11ZAzNZTJ6qw= =SkXT -----END PGP SIGNATURE-----
oops. I forgot to reply to the list. On Thursday 14 August 2003 06:45 pm, you wrote: > On Thursday 14 August 2003 06:10 pm, you wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > Hello, > > I have an old-ish Sybase dbms (SQL Anywhere v5.x) that does not offer a > > DUMP command. The only way to extract data is to SELECT all of it, then > > OUTPUT it in some format: csv, dbase2, dbase3, etc. > > I searched the docs and faqs for information on importing data and > > could not find anything about importing data. > > I am (still) using os/2 so most (all?) of the GUI options are not > > available to me. > > > > :-\ > > > > postgresql v7.3.2 > > > > > > - -- > > jimoe at sohnen-moe dot com > > What you're looking for is COPY: > > http://www.postgresql.org/docs/7.3/static/sql-copy.html > > Best of luck, > > Andrew Gould
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thu, 14 Aug 2003 18:48:43 -0500, Andrew L. Gould wrote: >> >> What you're looking for is COPY: >> >> http://www.postgresql.org/docs/7.3/static/sql-copy.html >> Thanks! That was it. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/PGLlsxxMki0foKoRAnj/AJ9Oq01ob0MxXZnTOrWeBAT84yyJtgCffoDA CfVwuw1qdJVqwnBLWfl0ib8= =8V00 -----END PGP SIGNATURE-----