On Thu, Jun 19, 2008 at 6:54 PM, Bill Thoen <[EMAIL PROTECTED]> wrote: > I've got to load some large fixed-legnth ASCII records into PG and I was > wondering how this is done. The Copy command looks like it works only with > delimited files, and I would hate to have to convert these files to > INSERT-type SQL to run them through psql.. Is there a way one can specify a > table structure with raw field widths and then just pass it a flat file?
You'll need to use something external to PG, like sed, awk or Perl, to convert to a delimited file, then load with COPY. -Doug -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
