Feature Request - Table Definition query - Mailing list pgsql-hackers

From Wilfried Schobeiri
Subject Feature Request - Table Definition query
Date
Msg-id 8F38740B-B490-4D19-AD04-8DD52482578E@videofurnace.com
Whole thread Raw
Responses Re: Feature Request - Table Definition query
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Window Functions: v07 APIs and buffering strateties
Next
From: Simon Riggs
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Rework subtransaction commit protocol for hot standby.