[mapguide-users] Connect to PostGis3.2 data
euskalmap
ziburudebian at free.fr
Fri Jun 5 03:31:23 EDT 2009
Hi,
So i have send the response of your query; it seems ok. Have you another
idea?
thanks
Password : root
Service : mydatabase at mymachine:5432
Datastore : public
If you have a logged provider, you should see some interesting query
The first one will scans all avalable table/views
SELECT n.nspname AS schemaname,c.relname AS tablename
FROM pg_class c, pg_namespace n
WHERE c.relnamespace = n.oid AND
c.relkind IN ('r','v') AND
(c.relname NOT LIKE 'pg_%') AND
(c.relname NOT LIKE 'spatial_ref_sys%') AND
(c.relname NOT LIKE 'sql_%') AND
(c.relname NOT LIKE 'geom%') AND
n.nspname = 'public'
ORDER BY c.relname
You should try to run it on your machine (replace public by your own schema)
The second one is runned for each table/view
SELECT a.attnum AS ordinal_position, a.attname AS column_name,t.typname AS
data_type, a.attlen AS character_maximum_length,a.atttypmod AS modifier,
a.attnotnull AS notnull,a.atthasdef AS hasdefault, d.adsrc AS
defaultVal,a.attnum = ANY (i.indkey) AS isprimarykey, i.indkey AS primKey,
i.indisprimary AS indisprimary
FROM pg_attribute a LEFT OUTER JOIN pg_attrdef d ON a.attrelid = d.adrelid,
pg_type t,
pg_namespace n,
pg_class c LEFT OUTER JOIN pg_index i ON i.indrelid = c.oid
WHERE a.attnum > 0 AND a.attrelid = c.oid AND
a.atttypid = t.oid AND
c.relnamespace = n.oid AND
t.typname !~ '^geom' AND
i.indisprimary = 't' AND
c.relname = 'mytable' AND
n.nspname = 'public'
ORDER BY a.attnum;
Try this and tell me what it returns
Bruno
--
View this message in context: http://n2.nabble.com/Connect-to-PostGis3.2-data-tp2980072p3028950.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
More information about the mapguide-users
mailing list