DEFINITIONS

Definitions More Info.
Definition ID915
TitlePOSTGRESQL
CategoryNOTES
Definitionfonksiyonlarin bulunmasi-find functions-probin
Definition Descriptionhttps://www.postgresql.org/message-id/CAOC%2BFBXSDTBMLPDfF8AdNpumT2hehdLMfuGVVSWabsoF1re33w%40mail.gmail.com

-- Asagidaki fonksiyon istediginiz bir foknsiyonu geiitrir.
select * from pg_proc where probin like '%tsearch%';


--Asagidaki sorgu sistem fonksiyonlari disindaki fonksiyonlarin listelenmesini saglar
select
pp.proname,
pl.lanname,
pn.nspname,
pg_get_functiondef(pp.oid)
from pg_proc pp
inner join pg_namespace pn on (pp.pronamespace = pn.oid)
inner join pg_language pl on (pp.prolang = pl.oid)
where pl.lanname NOT IN ('c','internal')
and pn.nspname NOT LIKE 'pg_%'
and pn.nspname <> 'information_schema';
RecordBycunay
Record Date22-01-2019 11:27:32
Düzenle
Kopyala
Sil