Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: How to get table definition of a PostgreSQL table
- From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
- To: pgsql-interfaces(at)postgresql(dot)org
- Cc: Sandeep Khandelwal <sandeep_khandelwal27(at)yahoo(dot)com>
- Subject: Re: How to get table definition of a PostgreSQL table
- Date: Fri, 27 Oct 2006 06:53:18 -0400
On Friday 27 October 2006 02:25, Sandeep Khandelwal wrote: > 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. See these two chapters in the postgresql docs: http://www.postgresql.org/docs/8.1/interactive/catalogs.html http://www.postgresql.org/docs/8.1/interactive/information-schema.html Each has advantages over the other. Also, if you start psql with the flag --echo-hidden, when you do commands like \dt and \d+, psql will show you the sql it uses to produce that output. Sean
- References:
- How to get table definition of a PostgreSQL table
- From: Sandeep Khandelwal
- How to get table definition of a PostgreSQL table
- Prev by Date: How to get table definition of a PostgreSQL table
- Next by Date: Re: pg_exec commit causes extremely long delays
- Previous by thread: How to get table definition of a PostgreSQL table
- Next by thread: Re: How to get table definition of a PostgreSQL table
- Indexes: