Re: Carrage Returns \ Line Breaks!
От | Brian C. Doyle |
---|---|
Тема | Re: Carrage Returns \ Line Breaks! |
Дата | |
Msg-id | 5.0.2.1.2.20001218115343.06c99e20@pop.mindspring.com обсуждение исходный текст |
Ответ на | Carrage Returns \ Line Breaks! ("Brian C. Doyle" <bcdoyle@mindspring.com>) |
Ответы |
Re: Carrage Returns \ Line Breaks!
|
Список | pgsql-general |
Okay now I am an Idoit. How do I tell what is used for the carriage return? I know how to make the replacement I just can not tell they characters used. At 11:52 AM 12/18/00 -0500, Brett W. McCoy wrote: >On Mon, 18 Dec 2000, Brian C. Doyle wrote: > > > I have a file that I am trying to import/copy into a table. The problem > > that I am having is that there are carriage returns through out the > > document. These carriage returns should be copied into the column it > > belongs to yet during the > > copy table from '/home/location/file.ext' using delimiters '|'; > > > > I get errors when it hits the carriage return. Can i get around this? > >You should convert the carriage returns into the literal text '\n'. Are >they ^J or ^M? > >-- Brett > http://www.chapelperilous.net/~bmccoy/ >--------------------------------------------------------------------------- >A soft answer turneth away wrath; but grievous words stir up anger. > -- Proverbs 15:1
В списке pgsql-general по дате отправления: