Re: Importing data

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

In response to

Responses

Browse pgsql-general by date

  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