1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

[SQL] PostgreSQL - How to extract table names used inside a function (code tab)

Discussão em 'Outras Linguagens' iniciado por Stack, Outubro 1, 2024.

  1. Stack

    Stack Membro Participativo

    I am trying to extract out all the tables which are being used for a stored procedure/function in PostgreSQL. However, I am only able to extract the function definition which is not needed.

    Below is my current code:

    select pg_get_functiondef(oid)
    from pg_proc
    where proname = 'functionname';


    [​IMG]

    Continue reading...

Compartilhe esta Página