Re: How to get geometry enabled Tables form Postgresql/postgis

Dear Lee,

Perfect ....Its working fine.... Thanks alot..

Thanks and Regards,

Venkat

On Fri, Jul 30, 2010 at 1:43 AM, Lee Hachadoorian <
lee(dot)hachadoorian(at)gmail(dot)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
>
>