Postgres Pro
Downloads
Home   >   mailing lists

How to get table definition of a PostgreSQL table - Mailing list pgsql-interfaces

From Sandeep Khandelwal
Subject How to get table definition of a PostgreSQL table
Date
Msg-id 20061027062556.97956.qmail@web33305.mail.mud.yahoo.com
Whole thread Raw
Responses Re: How to get table definition of a PostgreSQL table
List pgsql-interfaces
Tree view 
Hi.

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

Thanks,
Sandeep

pgsql-interfaces by date:

Previous
From: "Carlo Stonebanks"
Date:
Subject: pg_exec commit causes extremely long delays
Next
From: Sean Davis
Date:
Subject: Re: How to get table definition of a PostgreSQL table