Re: Can I get Field informations from system tables? - Mailing list pgsql-general

From Sam Mason
Subject Re: Can I get Field informations from system tables?
Date
Msg-id 20090813172223.GG5407@samason.me.uk
Whole thread Raw
In response to Can I get Field informations from system tables?  (Durumdara <durumdara@gmail.com>)
List pgsql-general
On Thu, Aug 13, 2009 at 05:20:22PM +0200, Durumdara wrote:
> I must get informations about the tables.
> For example:
> Tnnn:
> 1. [Field Name, Type, Size, NotNull]
> 2. [Field Name, Type, Size, NotNull]

I'd recommend either using the standard defined information_schema[1] or
playing around with running psql with -E.

--
  Sam  http://samason.me.uk/

 [1] http://www.postgresql.org/docs/current/static/information-schema.html

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: PostgreSQL for Firefox Bookmarks?
Next
From: Radoslaw Zielinski
Date:
Subject: Re: 8.4.0 bug - failure to enforce a foreign key constraint