Skip site navigation (1) Skip section navigation (2)

Standard metadata queries

From: Steve Atkins <steve(at)blighty(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Standard metadata queries
Date: 2008-04-24 18:01:13
Message-ID: 17C86589-F549-4EA0-A0F1-CE0F77000AF3@blighty.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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 are the names and types of each field of this  
table?".

These seem like queries that'll be used by a lot of people, hidden  
down in ORMs and access libraries, and which are hard to get right,  
let alone efficient, and which will generally be written by one person  
(developing the ORM or library) and likely not touched again.

Is there a standard set of well-crafted implementations of these  
anywhere that could be used by all the interface and ORM developers?  
If not, would it make sense to put some together and document or wiki  
them? Both as example code and as a set of good, solid queries that  
library developers can cut and paste.

(The implementation I'm looking at right now has, amongst other  
things, hardwired OID-to-type mappings, and there's got to be a  
cleaner way than that).

Cheers,
   Steve


Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2008-04-24 18:12:58
Subject: Re: Standard metadata queries
Previous:From: Brendan JurdDate: 2008-04-24 17:59:47
Subject: Re: [GENERAL] I think this is a BUG?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group