From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | postgres copy command |
Date: | 2001-11-05 15:48:01 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB03FFFF6B@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | david morgan | 2001-11-05 16:07:12 | Re: Stored procedures |
Previous Message | Brian Hirt | 2001-11-05 15:44:19 | Re: request for advise |