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.
Show quoted text
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: SHA1Hello,
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 comWhat you're looking for is COPY:
http://www.postgresql.org/docs/7.3/static/sql-copy.html
Best of luck,
Andrew Gould
Import Notes
Reply to msg id not found: 200308141845.58788.algould@datawok.com
-----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:
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-----