pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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>
  2000-08-23 14:42 ` Re: Copy To - fixed width 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:38 Copy To - fixed width Adam Lang <aalang@rutgersinsurance.com>
@ 2000-08-23 14:42 ` 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