| From: | Erik Price <eprice(at)ptc(dot)com> |
|---|---|
| To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: tablemeta-data |
| Date: | 2003-05-23 18:45:06 |
| Message-ID: | 3ECE6C32.2050204@ptc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bruno Wolff III wrote:
> On Thu, May 22, 2003 at 12:58:21 -0400,
> Erik Price <eprice(at)ptc(dot)com> wrote:
>
>>Hi,
>>
>>Is there a way to execute a query that returns meta-data about the
>>tables? Specifically I am interested in a psql command to display
>>information about a table's column names and types.
>
>
> \d table_name
>
> Use \? to get a list of \ commands.
Thanks everyone for these commands. I thought I had read through the
options in "\?" but guess I didn't look too closely. This is exactly
what I was looking for.
Regards,
Erik
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-05-23 19:03:58 | Re: UFS Logging on Solaris 8 |
| Previous Message | Manfred Koizar | 2003-05-23 18:30:03 | Re: [ADMIN] Q: Structured index - which one runs faster? |