postgres copy command

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

Responses

Browse pgsql-general by date

  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