[GENERAL] Can I get Field informations from system tables?

2009-08-13 Thread Durumdara
Hi! I must get informations about the tables. For example: Tnnn: 1. [Field Name, Type, Size, NotNull] 2. [Field Name, Type, Size, NotNull] ... The test table is this: CREATE TABLE testfields ( fbigint bigint NOT NULL, fbool boolean, fchar character(100), fcharv character varying(100),

Re: [GENERAL] Can I get Field informations from system tables?

2009-08-13 Thread Sam Mason
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