From: | "Command Prompt, Inc(dot)" <pgsql-general(at)commandprompt(dot)com> |
---|---|
To: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: postgres copy command |
Date: | 2001-11-06 00:13:34 |
Message-ID: | Pine.LNX.4.30.0111051613150.9889-100000@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)commandprompt(dot)com
http://www.postgresql.info/
http://www.commandprompt.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Command Prompt, Inc. | 2001-11-06 00:16:46 | Re: Stored procedures |
Previous Message | Bruce Momjian | 2001-11-06 00:12:29 | Re: Drop column and multiple db query |