Postgres Pro
Downloads
Home   >   mailing lists

Copy To - fixed width - Mailing list pgsql-sql

From Adam Lang
Subject Copy To - fixed width
Date
Msg-id 00b001c00d0f$bc730920$330a0a0a@Adam
Whole thread Raw
In response to Re: Using SETOF in plpgsql function  (Andreas Tille <tillea@rki.de>)
List pgsql-sql
Tree view 
Is it possible to copy from a text file that has the fields as fixed width
with no delimiter to a table?

The other option is a CSV file... but then how do I handle if there is a
comma in one of the fields?

I'm transfering information from an AS/400 ... if it is into a text file, it
is fixed width, if I use Excel, it is Comma separated.

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Date of creation and of change
Next
From: "Adam Lang"
Date:
Subject: Re: Copy To - fixed width