begin;
SELECT g.f_table_catalog,g.f_table_schema,g.f_table_name,g.f_geometry_column,g.coord_dimension,g.srid,g.type,has_table_privilege('postgres', g.f_table_schema || '.' || g.f_table_name, 'select') AS visible,(has_table_privilege('postgres', g.f_table_schema || '.' || g.f_table_name, 'delete') AND has_table_privilege('postgres', g.f_table_schema || '.' || g.f_table_name, 'insert') AND has_table_privilege('postgres', g.f_table_schema || '.' || g.f_table_name, 'update')) AS editable,(SELECT NonNullValue(ic.relname) AS has_idx FROM pg_class ic,pg_index ii,pg_opclass oc WHERE ii.indrelid = c.oid AND ii.indexrelid = ic.oid AND ii.indkey[0] = a.attnum AND ii.indclass[0] = oc.oid AND (oc.opcname = 'gist_geometry_ops' OR oc.opcname = 'gist_lwgeom_ops') AND ic.relkind = 'i') AS hasidx,a.atttypid FROM geometry_columns g,pg_class c,pg_attribute a,pg_namespace n WHERE c.relname = g.f_table_name AND n.nspname = g.f_table_schema AND (c.relkind = 'r' OR c.relkind = 'v') AND c.relnamespace = n.oid AND a.attrelid = c.oid AND a.attname = g.f_geometry_column LIMIT 0;
DECLARE C1 BINARY NO SCROLL CURSOR FOR SELECT g.f_table_catalog,g.f_table_schema,g.f_table_name,g.f_geometry_column,g.coord_dimension,g.srid,g.type,has_table_privilege('postgres', g.f_table_schema || '.' || g.f_table_name, 'select') AS visible,(has_table_privilege('postgres', g.f_table_schema || '.' || g.f_table_name, 'delete') AND has_table_privilege('postgres', g.f_table_schema || '.' || g.f_table_name, 'insert') AND has_table_privilege('postgres', g.f_table_schema || '.' || g.f_table_name, 'update')) AS editable,(SELECT NonNullValue(ic.relname) AS has_idx FROM pg_class ic,pg_index ii,pg_opclass oc WHERE ii.indrelid = c.oid AND ii.indexrelid = ic.oid AND ii.indkey[0] = a.attnum AND ii.indclass[0] = oc.oid AND (oc.opcname = 'gist_geometry_ops' OR oc.opcname = 'gist_lwgeom_ops') AND ic.relkind = 'i') AS hasidx,a.atttypid FROM geometry_columns g,pg_class c,pg_attribute a,pg_namespace n WHERE c.relname = g.f_table_name AND n.nspname = g.f_table_schema AND (c.relkind = 'r' OR c.relkind = 'v') AND c.relnamespace = n.oid AND a.attrelid = c.oid AND a.attname = g.f_geometry_column;
MOVE ABSOLUTE 0 IN C1;
FETCH FORWARD 256 IN C1;
CLOSE C1;
SELECT srid, auth_name, auth_srid, srtext FROM spatial_ref_sys WHERE srid in (4326) ORDER BY srid LIMIT 0;
DECLARE C2 BINARY NO SCROLL CURSOR FOR SELECT srid, auth_name, auth_srid, srtext FROM spatial_ref_sys WHERE srid in (4326) ORDER BY srid;
MOVE ABSOLUTE 0 IN C2;
FETCH FORWARD 256 IN C2;
CLOSE C2;
SELECT a.attname,a.atttypid,a.attlen,a.atttypmod,a.attnotnull,(SELECT ad.adsrc FROM pg_attrdef ad WHERE ad.adrelid = c.oid AND ad.adnum = a.attnum) AS def FROM pg_attribute a,pg_class c,pg_namespace n WHERE n.oid = c.relnamespace AND a.attrelid = c.oid AND a.attnum > 0 AND n.nspname = 'public' AND c.relname = 'world' ORDER BY a.attnum LIMIT 0;
DECLARE C3 BINARY NO SCROLL CURSOR FOR SELECT a.attname,a.atttypid,a.attlen,a.atttypmod,a.attnotnull,(SELECT ad.adsrc FROM pg_attrdef ad WHERE ad.adrelid = c.oid AND ad.adnum = a.attnum) AS def FROM pg_attribute a,pg_class c,pg_namespace n WHERE n.oid = c.relnamespace AND a.attrelid = c.oid AND a.attnum > 0 AND n.nspname = 'public' AND c.relname = 'world' ORDER BY a.attnum;
MOVE ABSOLUTE 0 IN C3;
FETCH FORWARD 256 IN C3;
CLOSE C3;
select * from world limit 0;
DECLARE C4 BINARY NO SCROLL CURSOR FOR select * from world limit 0;
MOVE ABSOLUTE 0 IN C4;
FETCH FORWARD 256 IN C4;
select castfunc from pg_cast where castsource = 128790 and casttarget = 25 LIMIT 0;
DECLARE C5 BINARY NO SCROLL CURSOR FOR select castfunc from pg_cast where castsource = 128790 and casttarget = 25;
MOVE ABSOLUTE 0 IN C5;
FETCH FORWARD 256 IN C5;
CLOSE C5;
CLOSE C4;
select country,capital,pop_1994,pop_grw_rt,pop_male,pop_fem,pop_0_14,pop_15_64,pop_65plus,male_0_14,male_15_64,male_65plus,fem_0_14,fem_15_64,fem_65plus,pop_urban,pop_rural,pop_urb_male,pop_urb_fem,pop_rur_male,pop_rur_fem,arable_pct,literacy,inflat_rate,unempl_rate,indust_growth,continent,AsBinary(geometry) AS geometry,OID from world where false LIMIT 0;
DECLARE C6 BINARY SCROLL CURSOR FOR select country,capital,pop_1994,pop_grw_rt,pop_male,pop_fem,pop_0_14,pop_15_64,pop_65plus,male_0_14,male_15_64,male_65plus,fem_0_14,fem_15_64,fem_65plus,pop_urban,pop_rural,pop_urb_male,pop_urb_fem,pop_rur_male,pop_rur_fem,arable_pct,literacy,inflat_rate,unempl_rate,indust_growth,continent,AsBinary(geometry) AS geometry,OID from world where false;
FETCH ABSOLUTE 1 IN C6;
--CLOSE C6;
select estimated_extent('public', 'world', 'geometry') LIMIT 0;
DECLARE C7 NO SCROLL CURSOR FOR select estimated_extent('public', 'world', 'geometry');
end;