Re: massive quotes?

Andrew Dunstan <andrew@dunslane.net> writes:
> 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?

Please see the archives.  I think that what was being discussed was
something along the lines of
foo=> CREATE FUNCTION myfunc(...) RETURNS ... ASfoo=> \beginliteralfoo'> type my function definition herefoo'> and
herefoo'>\endliteralfoo-> LANGUAGE plpgsql;
 

and psql would proceed to quotify whatever you entered between
the two backslash commands.  (Notice this could be used for any
string-literal entry problem, not only CREATE FUNCTION.)  I'm fuzzy on
the details though; this may not have been the best idea presented.
        regards, tom lane