Re: postgres copy command

Hi Shaunn,

The best detailed information I can think of is the guide which Jeff
Eckerman wrote "How to use PostgreSQL's COPY function effectively" :

http://techdocs.postgresql.org/techdocs/usingcopy.php

:-)

Regards and best wishes,

Justin Clift


"Command Prompt, Inc." wrote:
>
> Hello,
>
> The following URL from our book Practical PostgreSQL should help you out:
>
> http://www.postgresql.info/x5371.htm
>
> J
>
> On Mon, 5 Nov 2001, Johnson, Shaunn wrote:
>
> > Howdy:
> >
> > Regarding the copy command, are there any examples
> > as to it's usage?  Let me give you some background on
> > what I'm doing.
> >
> > >From my DB2/Mainframe to NT/DB2Connect environment, I have
> > an SQL script that pulls data down.  I can append the
> > data into a flat ASCII file format, but because some of the data
> > in some columns are broken up, it doesn't seem possible to
> > import the data into Postgres.  (e.g., the address col. may
> > have "66 w. baker street" ... but the format of the file is
> > space delimited, so each group of words are looked at as a
> > column).
> >
> > DB2 will, however, let me create a file that is a binary
> > format. (e.g., EXPORT to F:\backup\test.ixf of IXF)
> > After looking at some of the Postgres documentation,
> > there is a copy command that says, 'copies data between files
> > and tables'.
> >
> > Now, I'm trying to figure out how can I copy this binary file
> > and load it into a table on Postgres?  Is it possible?
> >
> > Thanks!
> >
> > -X
> >
>
> --
> --
> by way of pgsql-general@commandprompt.com
> http://www.postgresql.info/
> http://www.commandprompt.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi