| From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | db(at)juventuz(dot)net |
| Subject: | Re: pg environment? metadata? |
| Date: | 2003-02-18 12:13:30 |
| Message-ID: | 3E52236A.2E412B2@rodos.fzk.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> >
> > 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-02-18 13:35:12 | Re: [HACKERS] Group by, count, order by and limit |
| Previous Message | Christoph Haller | 2003-02-18 10:18:05 | Re: Group by, count, order by and limit |