Received: from web20803.mail.yahoo.com (web20803.mail.yahoo.com [216.136.226.192]) by postgresql.org (8.11.3/8.11.4) with SMTP id fA6Gcgm64617 for ; Tue, 6 Nov 2001 11:38:42 -0500 (EST) (envelope-from jeff_eckermann@yahoo.com) Message-ID: <20011106163842.90342.qmail@web20803.mail.yahoo.com> Received: from [65.11.165.34] by web20803.mail.yahoo.com via HTTP; Tue, 06 Nov 2001 08:38:42 PST Date: Tue, 6 Nov 2001 08:38:42 -0800 (PST) From: Jeff Eckermann Subject: Re: copy command with PSQL To: shaunnx@my-deja.com, pgsql-general@postgresql.org In-Reply-To: <6375fd1b.0111051013.f75fed6@posting.google.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/229 X-Sequence-Number: 17227 You need some kind of field separator in your data, a single character that is not found elsewhere in your data. That means you will need to find a way to get your source application to export the data with separator characters in place; or else you will need to edit the output to add those separators. How you do the editing depends on the nature of the data and the format of the output. If you send me a sample I may be able to suggest something for you (if the first alternative is unworkable for you). I have written some notes on the use of "copy", which you can find at the techdocs site: http://techdocs.postgresql.org --- X wrote: > Sorry if this is a repost -- > > 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 > > ---------------------------(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 __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com