pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to get geometry enabled Tables form Postgresql/postgis
3+ messages / 2 participants
[nested] [flat]
* How to get geometry enabled Tables form Postgresql/postgis
@ 2010-07-29 12:58 venkat <ven.tammineni@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: venkat @ 2010-07-29 12:58 UTC (permalink / raw)
To: pgsql-sql; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to get geometry enabled Tables form Postgresql/postgis
@ 2010-07-29 20:13 Lee Hachadoorian <lee.hachadoorian@gmail.com>
parent: venkat <ven.tammineni@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Lee Hachadoorian @ 2010-07-29 20:13 UTC (permalink / raw)
To: pgsql-sql
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
All geometric columns in all spatially enabled tables appear in the
table public.geometry_columns, defined as:<br>
<br>
<pre>CREATE TABLE public.geometry_columns</pre>
<pre>(</pre>
<pre> f_table_catalog character varying(256) NOT NULL,</pre>
<pre> f_table_schema character varying(256) NOT NULL,</pre>
<pre> f_table_name character varying(256) NOT NULL,</pre>
<pre> f_geometry_column character varying(256) NOT NULL,</pre>
<pre> coord_dimension integer NOT NULL,</pre>
<pre> srid integer NOT NULL,</pre>
<pre> "type" character varying(30) NOT NULL,</pre>
<pre> CONSTRAINT geometry_columns_pk PRIMARY KEY (f_table_catalog, f_table_schema, f_table_name, f_geometry_column)</pre>
<pre>)</pre>
<pre>WITH (</pre>
<pre> OIDS=TRUE</pre>
<pre>);</pre>
<br>
For tables only, a simple <br>
<pre>SELECT DISTINCT f_table_schema, f_table_name FROM geometry_columns; </pre>
should do the trick. <br>
<br>
--Lee<br>
<br>
On 07/29/2010 08:58 AM, venkat wrote:
<blockquote
cite="mid:AANLkTi=xDoxzM_WZwpBh04zxqj=-GCdxjW1te7DPx3=s@mail.gmail.com"
type="cite"><font color="#3366ff"><span class="Apple-style-span"
style="color: rgb(0, 0, 0);"><font color="#3366ff">Dear All,</font>
<div><font color="#3366ff"><br>
</font></div>
<div><font color="#3366ff"><br>
</font></div>
<div><font color="#3366ff"> How can i retrieve only spatial
enabled tables form the database(Postgresql/PostGIS).Please let me
know. </font></div>
<div><font color="#3366ff"><br>
</font></div>
<div><font color="#3366ff">I am waiting for your great response.</font></div>
<div><font color="#3366ff"><br>
</font></div>
<div><font color="#3366ff">Thanks and Regards,</font></div>
<div><font color="#3366ff"><br>
</font></div>
<div><font color="#3366ff">Venkat</font></div>
</span></font></blockquote>
<br>
<pre class="moz-signature" cols="72">--
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center
</pre>
</body>
</html>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: How to get geometry enabled Tables form Postgresql/postgis
@ 2010-07-30 04:27 venkat <ven.tammineni@gmail.com>
parent: Lee Hachadoorian <lee.hachadoorian@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: venkat @ 2010-07-30 04:27 UTC (permalink / raw)
To: Lee Hachadoorian <lee.hachadoorian@gmail.com>; +Cc: pgsql-sql
Dear Lee,
Perfect ....Its working fine.... Thanks alot..
Thanks and Regards,
Venkat
On Fri, Jul 30, 2010 at 1:43 AM, Lee Hachadoorian <
lee.hachadoorian@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
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2010-07-30 04:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-29 12:58 How to get geometry enabled Tables form Postgresql/postgis venkat <ven.tammineni@gmail.com>
2010-07-29 20:13 ` Lee Hachadoorian <lee.hachadoorian@gmail.com>
2010-07-30 04:27 ` venkat <ven.tammineni@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox