| From: | Thomas Swan <tswan-lst(at)tangent(dot)ics(dot)olemiss(dot)edu> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tim Perdue <tim(at)sourceforge(dot)net> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)hub(dot)org |
| Subject: | Re: postgres 7.0.2 |
| Date: | 2000-08-22 16:22:23 |
| Message-ID: | 5.0.0.13.2.20000822111739.02c7ec80@tangent.ics.olemiss.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
At 8/22/2000 11:54 AM -0400, Tom Lane wrote:
> > What would it take for you to map "show databases" to get that same
> > output? Same for "show tables" and "describe tbl_name". I think these
> > are standard SQL conventions which would be helpful for a lot of people.
>
>I don't see anything about such commands in the spec ;-). These things
>strike me as user-interface operations rather than something the backend
>ought to provide on its own.
Actually, I think I understand the question. The original person wants to
be able to do a query and get a result containing a list of
databases. AFAIK, there isn't a way to do this using standard SQL-like
statements. Somebody correct me if I'm wrong.
Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roderick A. Anderson | 2000-08-22 16:37:42 | [Solved] SQL Server to PostgreSQL |
| Previous Message | Thomas Swan | 2000-08-22 16:16:50 | Re: postgres 7.0.2 |