TODO: Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(), pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef() - Mailing list pgsql-hackers

From Joshua D. Drake
Subject TODO: Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(), pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
Date
Msg-id 448A41F2.7000208@commandprompt.com
Whole thread Raw
Responses Re: TODO: Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(), pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
List pgsql-hackers
Hello,

I can guess some of these:

pg_get_tabledef() : Would take a table name and return the columns and 
associated types

pg_get_acldef(): Would take an object name and return the associated 
roles and permissions for the object

pg_get_typedefault(): This one I am unsure about

pg_get_attrdef(): This one I am unsure about

pg_get_domaindef(): Would take the name of a domain constraint and 
return the definition

pg_get_functionef(): Would take the name of a function and return its 
soure. However, a function can have the same name with different
arguments, so I am a little unsure.

So could I get some further definition?

Joshua D. Drake



pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: How to avoid transaction ID wrap
Next
From: "Mark Cave-Ayland"
Date:
Subject: Re: Proposal for debugging of server-side stored procedures