From: | webb sprague <wsprague(at)o1(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Fixed width COPY |
Date: | 2001-05-07 19:45:23 |
Message-ID: | 0105071545230J.14569@lappi.o1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Does anybody know of a good way to COPY a file into a table if the data is
based on fixed width format? Do I just have to write some code with
scanf(Ick)? For example (Sorry about the poor ASCII art formatting):
| FIELD DESCRIPTION LENGTH POSITION|
|_______________________________________________________|
| 1. Action (E=eff, D=del, P=pend eff) 1 1
| 2. Action Date (mmddyy) 6 2-7
| 3. Country Code 3 8-10
| 4. filler 1 11
5. Paired Code 3 12-14
| 6. filler 1 15
| 7. Country Name 65 16-80
| 8. Footnote code (LERGINFO, Sec 1.1) 1 81
| 9. filler 9 82-90
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-05-07 19:54:24 | Re: case insensitive unique index (part 2) |
Previous Message | Dave Cramer | 2001-05-07 19:44:06 | Re: Re: MS-Query |