> On 01/11/06, Matthew Flanagan <[EMAIL PROTECTED]> wrote: > > # select pg_constraint.conname, pg_constraint.contype, > pg_attribute.attname from pg_constraint, pg_attribute where > pg_constraint.conrelid=pg_attribute.attrelid and > pg_attribute.attnum=any(pg_constraint.conkey) and > pg_constraint.conname ~ '^myapp_foo'; > conname | contype | attname > ------------------------------------+------------+--------- > myapp_foo_pkey | p | id > myapp_footype_pkey | p | id > myapp_footype_name_key | u | name > (3 rows) > > This is where I reach the boundaries of my postgres knowledge. > > Any help would be appreciated. >
What do you want to do? I'm trying to see what you need and I'm not quite shure this is the correct way to do that. When you want to search data in the postgres catalog, there are some VIEWS you can use. so, What do you need? Regards! > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-developers@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-developers?hl=en -~----------~----~----~----~------~----~------~--~---
