Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 26 Oct 2006 23:25:56 -0700 (PDT)
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
- Follow-Ups:
- Re: How to get table definition of a PostgreSQL table
- From: Sean Davis
- Re: How to get table definition of a PostgreSQL table
- Prev by Date: Re: libpq PQexecPrepared returns NULL but all ok
- Next by Date: Re: How to get table definition of a PostgreSQL table
- Previous by thread: libpq PQexecPrepared returns NULL but all ok
- Next by thread: Re: How to get table definition of a PostgreSQL table
- Indexes: