I'm coding an application witch need column information type from a
PostgreSQL provider, using V4.
When I use gda-sql-4.0 I can see the following information:
List of columns for table 'prueba'
Column | Type | Nullable |
Default |
Extra
------------+-----------------+----------+------------------------------------+-
--------------
id | gint | no |
nextval('prueba_id_seq'::regclass) |
Auto increment
description | pg_catalog.text | yes |
But whe I get the columns in a GdaMetaStore using
SELECT column_name, gtype \
FROM _columns WHERE \
table_schema =
##schema::string AND \
table_catalog =
##catalog::string AND \
table_name = ##table::string
for the same table 'prueba' in the same DB, when I dump to string the
DataModel I got:
TABLE: prueba COLUMNS:
column_name | gtype
------------+-----------
description | gchararray
id | gchararray
The table type isn't the same using the different tools, why?
--
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)
_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list
