Re: [gnome-db] Column Type



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)


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]