Re: [HACKERS] Standard metadata queries

2008-04-24 Thread Decibel!
On Apr 24, 2008, at 1:01 PM, Steve Atkins wrote: I've been chatting with the Trolltech folks about the implementation of the Qt wrapper around libpq, and the issue of how to properly do metadata queries came up. That is things like "What are the column names and types of the primary key of t

Re: [HACKERS] Standard metadata queries

2008-04-24 Thread Steve Atkins
On Apr 24, 2008, at 2:22 PM, Tom Lane wrote: Steve Atkins <[EMAIL PROTECTED]> writes: On Apr 24, 2008, at 11:12 AM, Joshua D. Drake wrote: I believe the information_schema is standard. Standard, but woefully incomplete (by design). Sure, because it's restricted to standardized concepts.

Re: [HACKERS] Standard metadata queries

2008-04-24 Thread Tom Lane
Steve Atkins <[EMAIL PROTECTED]> writes: > On Apr 24, 2008, at 11:12 AM, Joshua D. Drake wrote: >> I believe the information_schema is standard. > Standard, but woefully incomplete (by design). Sure, because it's restricted to standardized concepts. Do the adapters in question need to obtain inf

Re: [HACKERS] Standard metadata queries

2008-04-24 Thread Steve Atkins
On Apr 24, 2008, at 11:12 AM, Joshua D. Drake wrote: On Thu, 24 Apr 2008 11:01:13 -0700 Steve Atkins <[EMAIL PROTECTED]> wrote: I've been chatting with the Trolltech folks about the implementation of the Qt wrapper around libpq, and the issue of how to properly do metadata queries came up. Th

Re: [HACKERS] Standard metadata queries

2008-04-24 Thread Joshua D. Drake
On Thu, 24 Apr 2008 11:01:13 -0700 Steve Atkins <[EMAIL PROTECTED]> wrote: > I've been chatting with the Trolltech folks about the implementation > of the Qt wrapper around libpq, and the issue of how to properly do > metadata queries came up. That is things like "What are the column > names

[HACKERS] Standard metadata queries

2008-04-24 Thread Steve Atkins
I've been chatting with the Trolltech folks about the implementation of the Qt wrapper around libpq, and the issue of how to properly do metadata queries came up. That is things like "What are the column names and types of the primary key of this table, and what index enforces it?" or "What