Re: querying for specs?

On Mon, Dec 17, 2001 at 11:51:44PM -0800, mjbjr(at)beaudesign(dot)com wrote:
> On Tue, Dec 18, 2001 at 05:31:55PM +1100, Martijn van Oosterhout wrote:
> > Question: Did you read the little help message that pops up when you start
> > psql?
> >
>
> Good point. I have, actually, though that was sometime ago, before these
> questions came to mind. I have been searching 'sql' docs as of late.
>
> For the most part, the slash commands will give me the answers I need.
>
> Can you get the answers I'm looking for using 'sql' commands that would work
> with any "standard" sql db engine?

Heh. I'm afraid that discovering the structure of a database was not
something standardised by the SQL standard. So every database does it
differently. I don't think there exist two databases that do it the same
way.

That said, it may be possible to discover various details using ODBC. After
all, Access does figure out a list of tables and how they're structured when
connecting remotely to a database. But I know of no actual tool to do it.

HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/
> Terrorists can only take my life. Only my government can take my freedom.