pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Copy To - fixed width 2+ messages / 1 participants [nested] [flat]
* Copy To - fixed width @ 2000-08-23 14:38 Adam Lang <aalang@rutgersinsurance.com> 0 siblings, 1 reply; 2+ messages in thread From: Adam Lang @ 2000-08-23 14:38 UTC (permalink / raw) To: ; +Cc: pgsql-sql 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Copy To - fixed width @ 2000-08-23 14:42 Adam Lang <aalang@rutgersinsurance.com> parent: Adam Lang <aalang@rutgersinsurance.com> 0 siblings, 0 replies; 2+ messages in thread From: Adam Lang @ 2000-08-23 14:42 UTC (permalink / raw) To: ; +Cc: pgsql-sql Sort of nevermind, can I can save it tab delimited, but I am still curious if it can be done using fixed width fields. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Adam Lang" <aalang@rutgersinsurance.com> Cc: <pgsql-sql@postgresql.org> Sent: Wednesday, August 23, 2000 10:38 AM Subject: [SQL] Copy To - fixed width > 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-08-23 14:42 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-08-23 14:38 Copy To - fixed width Adam Lang <aalang@rutgersinsurance.com> 2000-08-23 14:42 ` Adam Lang <aalang@rutgersinsurance.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox