> > > > I was wondering what kind of functions/constants exist in Postgre to dig > up > > metadata. I barely scratched the surface of Oracle but I know you find > > things like user_tables there that can be used to extract info about your > > tables. What I'm looking for is some kind of functions to extract column > > names, possibly data types, etc. And by that I don't mean console > commands, > > sql statements that will do the job with tcp/ip. > > > > Moreover, are there any ANSI standards for this kind of thing? Or each one > > to his own? > > Refer to the System Catalogs chapter within the Developer's Guide section of the documentation. In addition, if you start a psql session with the -E option, you will see how all these \d commands are generated. I would love to hear there is a standard about system catalogs, but I've never heard of one and I doubt there will be one ever in the future.
Regards, Christoph ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly