Dear Lee, Perfect ....Its working fine.... Thanks alot..
Thanks and Regards, Venkat On Fri, Jul 30, 2010 at 1:43 AM, Lee Hachadoorian < lee.hachadoor...@gmail.com> wrote: > All geometric columns in all spatially enabled tables appear in the table > public.geometry_columns, defined as: > > CREATE TABLE public.geometry_columns > > ( > > f_table_catalog character varying(256) NOT NULL, > > f_table_schema character varying(256) NOT NULL, > > f_table_name character varying(256) NOT NULL, > > f_geometry_column character varying(256) NOT NULL, > > coord_dimension integer NOT NULL, > > srid integer NOT NULL, > > "type" character varying(30) NOT NULL, > > CONSTRAINT geometry_columns_pk PRIMARY KEY (f_table_catalog, > f_table_schema, f_table_name, f_geometry_column) > > ) > > WITH ( > > OIDS=TRUE > > ); > > > For tables only, a simple > > SELECT DISTINCT f_table_schema, f_table_name FROM geometry_columns; > > should do the trick. > > --Lee > > > On 07/29/2010 08:58 AM, venkat wrote: > > Dear All, > > > How can i retrieve only spatial enabled tables form the > database(Postgresql/PostGIS).Please let me know. > > I am waiting for your great response. > > Thanks and Regards, > > Venkat > > > -- > Lee Hachadoorian > PhD Student, Geography > Program in Earth & Environmental Sciences > CUNY Graduate Center > >
