From: | "Andrew L(dot) Gould" <algould(at)datawok(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Importing data |
Date: | 2003-08-14 23:48:43 |
Message-ID: | 200308141848.43598.algould@datawok.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas A. Lowery | 2003-08-15 01:38:00 | Re: Simple DBI question. |
Previous Message | James Moe | 2003-08-14 23:10:52 | Importing data |