Re: massive quotes?

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: massive quotes?
Date: 2003-09-10 23:57:24
Message-ID: 3F5FBA64.2040109@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andreas Pflug wrote:

>
> I never agreed that a client solution would be satisfying. While
> frontends might try to hide some uglyness of the syntax to the user
> for single functions, editing large scripts with many functions is
> still suffering from "massive quotes".
>
Yes, I agree that a psql-specific solution is not ideal, quite aside
from the problem of making it look nice. It would be better than
nothing, though.

Something that is done at the language level will be portable across
frontends, while something psql-specific will not. Also, pg_dump -s will
kindly restore all the quotes for you, so if you ever edit its output
(as I do sometimes) you'll have to convert stuff all over again,
although I guess pg_dump could be taught to re-unescape things. But then
that seems almost as much trouble as teaching the backend a bit of new
syntax.

For those reasons as well as the aesthetic ones I'd prefer a solution at
the language level.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruno Wolff III 2003-09-11 00:21:19 Re: Broken(?) 'interval' problems. [Was: ISO 8601 "Time Intervals"]
Previous Message Greg Stark 2003-09-10 23:20:48 Re: massive quotes?