[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] massive quotes?
From:       Andrew Dunstan <andrew () dunslane ! net>
Date:       2003-08-31 23:59:23
[Download RAW message or body]



Tom Lane wrote:

>Andrew Dunstan <andrew@dunslane.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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]