Re: massive quotes?

Tom Lane wrote:

>Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>
>>Tom Lane wrote:
>>
>>
>>>I'm also wondering why the backend need have anything at all to do with
>>>an improved function-definition mode. If you look in the archives you
>>>will see speculation about inventing psql backslash commands that would
>>>assist in entering raw function definitions by taking something you type
>>>and suitably quotifying it.
>>>
>>>
>
>
>
>>This would suit my needs, as I use psql to do my db setup. But it would
>>introduce a possible disconnect between psql and other interfaces, e.g.
>>pgadmin, wouldn't it? Might it not be better to do something that was at
>>least available to all clients, rather than make them all have to do
>>their own quote escaping?
>>
>>
>
>What makes you think that a COPY-based interface would be especially
>convenient for other frontends? In my mind this is entirely a
>user-interface matter, and as such is best solved at the user interface.
>psql has one set of needs, but a GUI app has totally different ones.
>I believe phpPgAdmin and so forth already have their own solutions to
>the quoting problem, anyway.
>

I was speculating, that it might. But I'm quite prepared to accept that
it wouldn't, and go for a purely psql solution, preferably one that
pg_dump can understand and use.

In that case, though, the solution will presumably look at least a bit
different from those discussed so far in this thread. Or would you have
psql detect that in place of a string there was "stdin" or whatever and
then replace it with the inline string before passing it to the backend?

cheers

andrew