How to get table definition of a PostgreSQL table

From: Sandeep Khandelwal <sandeep_khandelwal27(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: How to get table definition of a PostgreSQL table
Date: 2006-10-27 06:25:56
Message-ID: 20061027062556.97956.qmail@web33305.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hi.

I would like to get field's name, datatype of each field, length of each field and precision of each field of a PostgreSQL table. Please let me SQL query to get this information.

Thanks,
Sandeep

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Sean Davis 2006-10-27 10:53:18 Re: How to get table definition of a PostgreSQL table
Previous Message Tom Lane 2006-10-25 14:16:48 Re: libpq PQexecPrepared returns NULL but all ok