pg_get_functiondef(), trailing spaces and + sign
От | Ron |
---|---|
Тема | pg_get_functiondef(), trailing spaces and + sign |
Дата | |
Msg-id | 5e5c5f5f-7b98-fab1-ae9b-4072ee64058c@gmail.com обсуждение исходный текст |
Ответы |
Re: pg_get_functiondef(), trailing spaces and + sign
Re: pg_get_functiondef(), trailing spaces and + sign |
Список | pgsql-general |
Is there any direct way in Postgresql to get rid of the frankly anti-useful junk at the end of each line (which also infects pg_stat_activity.query), or must I resort to sed post-processing? test=# select pg_get_functiondef(oid) test-# from pg_proc test-# where proname = 'foo'; pg_get_functiondef ---------------------------------------------------- CREATE OR REPLACE FUNCTION public.foo(bar integer)+ RETURNS double precision + LANGUAGE plpgsql + AS $function$ + begin + return bar * 1.0; + end; + $function$ + (1 row) -- Born in Arizona, moved to Babylonia.
В списке pgsql-general по дате отправления: