[postgis-users] drop geometry_columns
Travis Kirstine
traviskirstine at gmail.com
Wed Dec 12 11:09:03 PST 2007
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-
------------------------------------------------------------
More information about the postgis-users
mailing list