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

2010-07-29 Thread venkat
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: > > CRE

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

2010-07-29 Thread Lee Hachadoorian
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 N

[SQL] How to get geometry enabled Tables form Postgresql/postgis

2010-07-29 Thread venkat
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