Hallo Oscar You can spatially enable any database by loading and running
lwpostgis.sqlandspatial_ref_sys.sql for instance in pgAdmin I think that's the
right name of the files for your version and you can find them in :C:\Program
files\PostgreSQL\8.3\share\contribor something corresponing on your
system.Probably you will have to remove the lines with "vacuum" in the
spatial_ref_sys.sql before running. That issue shoud be fixed in upcoming
PostGIS 1.5 But if you have the possibility you probably want to upgrade both
database and postgis. Latest stable now isPostgreSQL 8.4.2 and PostGIS 1.4.
Hopefully in a couple of weeks PostGIS 1.5 will be released. Hope that
helpsNicklas
2010-01-13 Oscar Zamudio wrote:
Hi everybody. I'm a newbie and trying to use PostGIS with PostgreSQL in
Windows. I installed PostgreSQL 8.3 and also PostGIS 1.3.6 using the
Application Stack Builder. Spatial queries are working fine but I have some
doubts about the PostGIS configuration. Where can I find the SPATIAL_REF_SYS
Table for example, or the GEOMETRY_COLUMNS table? At the time I was installing
the PostGIS extension I didn't check the creation of a postgis database. I
guess postgis database contains the tables that I'm looking for. Am I wrong? >
I was thinking in reinstall the PostGIS 1.3.6 and create the postgis database
but I don't know how, as the Application Stack Builder doesn't allow me to do
that. Can anybody help me? Thanks in advance
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
