Re: [gnome-db] Column Type

["Vivien Malerba" <vmalerba gmail com>]

2008/10/3 Daniel Espinosa <esodan gmail com>

Using Trunk Version 3222.

The table was created using the following SQL:

CREATE TABLE test (id serial primary key, description text);

With this function I get the following:

TABLE: test COLUMNS:

column_name | gtype      | data_type     
------------+------------+----------------
description | gchararray | pg_catalog.text
id          | gchararray | gint

The Query used to get this DataModel is:

SELECT column_name, gtype, data_type FROM _columns WHERE table_schema =  #schema::string AND table_catalog = ##catalog::string AND table_name = ##table::string

Ok I've corrected the problem in Rev #3224. Tell me if it's not OK for you!

Cheers,

Vivien