Feature Request - Table Definition query

From: Wilfried Schobeiri <schobeiriw(at)videofurnace(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Feature Request - Table Definition query
Date: 2008-10-28 19:04:59
Message-ID: 8F38740B-B490-4D19-AD04-8DD52482578E@videofurnace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Howdy!

It was suggested to me that this proposed feature is interesting
enough to be floated around for discussion.
Don't get your hopes up, because the request is extremely simple:

It could be useful to have a command that returns the table definition
(like pg_dump -st) from within the query interface. This could be
particularly useful if one doesn't have access to or prefers not to
manipulate results coming from a shell. If I have an API from which to
query the database, it seems silly to have to spawn a shell and run a
command to query the very same database.

(I'm not exactly familiar with how pg_dump manipulates or extracts
that data, so this could be a very, very stupid question. If so,
please forgive me.)

Regards,
Wilfried Schobeiri

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-10-28 19:22:20 Re: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby.
Previous Message Tom Lane 2008-10-28 18:55:16 Re: Window Functions: v07 APIs and buffering strateties