On Wed, 2003-06-04 at 22:28, Christopher Kings-Lynne wrote: > > Which ones are missing, and should we really be looking at creating a > > pg_definition_schema instead? > > Missing: > > Database, schema, table, domain, cast, conversion, function... > > Maybe a definition schema might be better.....dunno...it would need to use > the pg_get_*def functions anyway methinks.
As an interface writer, do you prefer dealing with functions like pg_get_constraintdef() or a view like the information schema provides? The function doesn't easily allow determination of items such as the ON UPDATE or ON DELETE type (statement parsing is required), but the information schema gives the information in a segregated manner. The pg_get_*def() functions seem to have been created primarily for psql and pg_dump. -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
Description: This is a digitally signed message part