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