| From: | Shridhar Daithankar <ghodechhap(at)ghodechhap(dot)net> |
|---|---|
| To: | Konstantin Danilov <danilov_konst(at)list(dot)ru> |
| Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to view the list of tables? |
| Date: | 2005-02-15 11:04:39 |
| Message-ID: | 200502151634.39458.ghodechhap@ghodechhap.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Tuesday 15 Feb 2005 3:46 pm, Konstantin Danilov wrote:
> Hello, list!
> I need to view the list of tables in a database. In MySQL I can do it with
> the command "SHOW TABLES". What about PostgreSQL? Can I also see somehow
> the datatypes of tables' fields?
In psql, you can try '\dt' and '\d table name'. Type \? for more commands..
Shridhar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoffrey | 2005-02-15 11:06:16 | Re: /usr/sbin/useradd is needed by postgresql-server-8.0.1-PGDG |
| Previous Message | Geoffrey | 2005-02-15 10:56:51 | Re: Lost rows/data corruption? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mihail Nasedkin | 2005-02-15 11:15:51 | Re: How to view the list of tables? |
| Previous Message | Dick Davies | 2005-02-15 10:49:30 | Re: How to view the list of tables? |