[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