Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference? - Mailing list pgsql-general

From Christopher Sawtell
Subject Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?
Date
Msg-id 01020811004200.00373@berty
Whole thread Raw
In response to Re: [SQL] Re: SQL Join - MySQL/PostgreSQL difference?  (Brice Ruth <brice@webprojkt.com>)
List pgsql-general
On Thu, 08 Feb 2001 05:38, Brice Ruth wrote:
> Is there a simple (unix) command I can run on text files to convert
> cr/lf to lf?  The way I did it seemed pretty ass-backward to me (not to
> mention time consuming).

This little heiroglyph will convert all text files rescued from that man's
system in a single directory to the format required by the one true way.

for f in `echo *`;  #  Change this to select files by regex if needed
do
 echo $f;
 cat $f | tr -d "\015\032" > $f.unix;
 mv $f.unix $f;
done

Don't forget to remove the control Z file terminator as well as the
superfluous CRs. It could cause very obtuse problems. Assumes you have
write permission to the directory.

pgsql-general by date:

Previous
From: "ross::barna"
Date:
Subject: ALTER DROP COLUMN
Next
From: Raymond Chui
Date:
Subject: How to make PostgreSQL JDBC drive get PGTZ?