[postgis-users] Anybody know anything about the Debian packages?

[Obe, Regina]

Paul,

You could also use the below trick to figure out the geometry tables.
The below will catch both tables and views that have geometry columns
and even when they weren't created the GOOD WAY with addgeometrycolumn.

SELECT DISTINCT table_schema, table_name 
FROM information_schema.columns
WHERE udt_name = 'geometry'
ORDER BY table_name

This will catch all public tables  except the geometry_columns and
spatial_ref_sys (you can filter out other tables as well.  I tend to
exclude things starting with pg as well.

SELECT DISTINCT table_schema, table_name 
FROM information_schema.tables
WHERE table_name NOT IN('spatial_ref_sys', 'geometry_columns') and
table_schema = 'public'
and table_name NOT LIKE 'pg%'
ORDER BY table_name

Hope that helps,
Regina


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Tomblin
Sent: Wednesday, April 02, 2008 9:19 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Anybody know anything about the Debian
packages?

Paul Tomblin wrote:
> I thought I might try the documented "hard upgrade" procedure to see
if 
> it will do what is in essence a downgrade.  But neither the "postgis" 
> nor the "postgresql-8.1-postgis" Debian packages seems to have
installed 
> the documented utils/postgis_restore.pl program.  Does anybody here
know 
> if it's in a different package, or can I just pull it from subversion?

Never mind.  I discovered that "pg_dump -c" with multiple "-t" options
naming 
all my tables works, providing that I'd pre-created all the tables with 
geometries so that the appropriate entries are in the geometry_columns
table.


-- 
Paul Tomblin <ptomblin at xcski.com> http://blog.xcski.com/
Of course, I also got weird looks when I said that, as a kid, I watched
the
toast brown in a toaster to see whether it browned at a linear or
exponential
rate.  -- Jeff Davis
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.