Re: [gnome-db] Column Type

["Daniel Espinosa" <esodan gmail com>]

Well Done!!! the problem gone, many thanks.

2008/10/3 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

--
Trabajar, la mejor arma para tu superación
"de grano en grano, se hace la arena" (R) (en trámite, pero para los cuates: LIBRE)