Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group