2010/1/29 Andre Fernandes <[email protected]>:

> Acho que a melhor maneira de fazer isso é usando o information_schema, use o
> seguinte select:
>
> select table_schema, table_name
> from information_schema.tables
> where table_name like '%sp_funcao%';

Hã?

Acho que vc quiz dizer:
SELECT routine_schema, routine_name
   FROM information_schema.routine
 WHERE routine_name = $$sp_funcao$$;


-Leo
-- 
Leonardo Cezar
http://www.aslid.org.br
http://postgreslogia.wordpress.com
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a