| From: | "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at> | 
|---|---|
| To: | Sujith C S <sujithcs(at)ddsl(dot)net>, PostgreSQL-Novice <pgsql-novice(at)postgreSQL(dot)org> | 
| Subject: | Re: | 
| Date: | 2000-10-28 14:36:14 | 
| Message-ID: | 20001028163613.A525@frithjof | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-novice | 
On Fri, Oct 27, 2000 at 06:32:15PM +0530, Sujith C S wrote:
> Sir.
> How to list the table names in SQL server using a query...
> Like Select * from tab in Oracle...
> Plz help.
In psql you can see that information with \d. Start psql with some
option (I think it is -E, see the man page or psql --help) to get the
actual queries sent to the backend.
Albert.
--
--------------------------------------------------------------------------
Albert Reiner                                   <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
Deutsch       *       English       *       Esperanto       *       Latine
--------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Larry Rosenman | 2000-10-29 02:29:06 | Re: REFERENCES in a field | 
| Previous Message | Radim Kolar | 2000-10-28 14:15:11 | There are only 4 bytes per OID |