Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
