Re: Importing data - Mailing list pgsql-general

From Andrew L. Gould
Subject Re: Importing data
Date
Msg-id 200308141848.43598.algould@datawok.com
Whole thread Raw
In response to Importing data  ("James Moe" <jimoe@sohnen-moe.com>)
Responses Re: Importing data  ("James Moe" <jimoe@sohnen-moe.com>)
List 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


pgsql-general by date:

Previous
From: "James Moe"
Date:
Subject: Importing data
Next
From: Mel Roman
Date:
Subject: Re: PostGreSQL - Accessing It