Re: [GENERAL] Fixed width COPY

2001-05-07 Thread Tom Lane
webb sprague <[EMAIL PROTECTED]> writes: > Does anybody know of a good way to COPY a file into a table if the data is > based on fixed width format? COPY insists on having delimiters; you'll need to translate the file format into something COPY can deal with. > Do I just have to write some code

[GENERAL] Fixed width COPY

2001-05-07 Thread webb sprague
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 DESCRIPTIONLENGTH POSITION| |___