Re: problem with CR+LF in files in psql \i command - Mailing list pgsql-patches

From Euler Taveira de Oliveira
Subject Re: problem with CR+LF in files in psql \i command
Date
Msg-id 20050326113225.17283.qmail@web54606.mail.yahoo.com
Whole thread Raw
In response to problem with CR+LF in files in psql \i command  ("Luiz K. Matsumura" <luiz@planit.com.br>)
List pgsql-patches
Hi Bruce,

> Function and comments are just _strings_ to PostgreSQL, so we have no
> good way of cleaning the output up, unless we hack pg_dump to somehow
> change line endings when outputting such information, though
> currently we
> don't.  The would perhaps cause problems in viewing the functions if
> restored in Win32.
>
Agreed.

> Fixing it at the \i level is too crude because it might remove
> carriage
> returns that are wanted in the input stream.
>
Agreed.

> We are open to ideas on how to improve this.
>
What about another option to pg_dump to indicate such a thing? Maybe -l
or --change-line [m|w|u]

Another TODO item?


Euler Taveira de Oliveira
euler[at]yahoo_com_br

__________________________________________________
Converse com seus amigos em tempo real com o Yahoo! Messenger
http://br.download.yahoo.com/messenger/

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: problem with CR+LF in files in psql \i command
Next
From: Manuel Baena García
Date:
Subject: Re: contrib dbf2sql.pl