| 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: | Whole Thread | Raw Message | 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 |