Jan-Peter.Seifert@xxxxxx writes: > I combined your suggestions into this query I'll be using for now: > SELECT DISTINCT n.nspname || '.' || p.oid::regprocedure::text FROM This is flat *wrong*, as you'll soon find if you are working with functions in more than one schema. regprocedure already puts a schema qualification on the name if one is needed. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
