Try this. SELECT probe_geometry_columns()
Bruce -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Travis Kirstine Sent: Wednesday, December 12, 2007 12:09 PM To: PostGIS Users Discussion Subject: [postgis-users] drop geometry_columns Hi, I am new to postgis and mistakenly dropped my geometry_columns table. Is there anyway to recreate the table (so things work again Geoserver)? or do I have to reload all my datasets (and add the table). CREATE TABLE geometry_columns ( f_table_catalog VARRCHAR(256) NOT NULL, f_table_schema VARCHAR(256) NOT NULL, f_table_nam VARCHAR(256) NOT NULL, f_geometry_column VARCHAR(256) NOT NULL, coord_dimension INTEGER NOT NULL, srid INTEGER NOT NULL, type VARCHAR(30) NOT NULL ) -- Travis K. Toronto, Canada ------------------------------------------------------------ "She knows there's no success like failure And that failure's no success at all." -Bob Dylan- ------------------------------------------------------------ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
