| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Alan Chandler <alan(at)chandlerfamily(dot)org(dot)uk>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Matching the MYSQL "Describe <table-name>" command |
| Date: | 2005-04-25 04:53:37 |
| Message-ID: | 10192.1114404817@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Stephen Frost <sfrost(at)snowman(dot)net> writes:
> You might want to take a look at the schema called 'information_schema'
> and see if you can find what you want there. The only problem I have
> with that, currently anyway, is that it seems to only show things the
> current user owns as opposted to what the current user has access to,
> which seems a bit silly to me.
The SQL99 spec defines some of the views as showing only what you own,
and others as showing whatever you have access to. I think we track
the spec, but feel free to point out discrepancies.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ramakrishnan Muralidharan | 2005-04-25 09:29:08 | Re: Looking for a way to sum integer arrays.... |
| Previous Message | Bruno Wolff III | 2005-04-25 04:23:27 | Re: to_char(interval) ? |