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
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
Fine.
Please advice me,
How long can
your table be? Thousands? Millions of records?
Do you really need it in pure SQL
?
It seems to me that it might be possible, I'm just affraid that the query
would become too complex and thus slow...
Best,
Oliveiros
- Original Message -
From: "R
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
No. This is by accident.
We have to assume that the combinations do change anytime, and many times per
day.
So
"Or is it possible to have the same combination on one day with several sets?"
YES!
Rainer
Am 29.07.2010 13:47, schrieb Oliveiros d'Azevedo Cristina:
> Yes. This is somewhat more
Yes. This is somewhat more complicated because it has more constraints.
I've noticed that a given combination doesn't appear with holes on a certain
day.
For ex, on a daily basis, we have every three key combinations together.
We dont have things like
2010-7-01 1726 3212 1428
2010-7-01 1726
Howdy Cristina,
unfortunately things are more complicated. I have inserted an excerpt of the
real data here:
TableID MasterID dtBegin dtEnd
idR id
Wes James, 28.07.2010 19:35:
I'm trying to do this:
select * from table where field::text ilike '%\_%';
but it doesn't work.
How do you escape the _ and $ chars?
The docs say to use \, but that isn't working.
( http://www.postgresql.org/docs/8.3/static/functions-matching.html )
The text bet
