Re: Better to dump tabs as tabs, or \t?

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Better to dump tabs as tabs, or \t?
Date: 2006-05-27 20:14:21
Message-ID: 4478B31D.9050907@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Historically pg_dump has taken pains to dump ASCII control characters
> as backslash constructs, for instance \t for tab. I am thinking this
> is not such a great idea, and that it'd be more portable rather than
> less so if we got rid of that logic and just dumped tab as tab, etc.
> In particular, making this play nice with standard_conforming_strings
> seems unpleasant: we'll have to emit E'' strings which are certainly
> not portable, not even to older PG releases.
>
> The only good argument I can see for the current behavior is that it
> makes the dump file somewhat more robust against whitespace-mashing
> filters like typical email programs. But I wouldn't count on a
> dump file to come through such a thing completely unscathed anyway.
>
>
>

Go for it.

Emailing a database dump as other than a properly encoded MIME
attachment makes no sense these days.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Kreen 2006-05-27 20:37:35 Re: Better to dump tabs as tabs, or \t?
Previous Message Tom Lane 2006-05-27 20:02:46 Better to dump tabs as tabs, or \t?