<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18854"></meta>
</head>
<body>Hallo Oscar
<div align="left"> </div>
<div align="left">You can spatially enable any database by loading and running </div>
<div align="left">lwpostgis.sql</div>
<div align="left">and</div>
<div align="left">spatial_ref_sys.sql</div>
<div align="left"> </div>
<div align="left">for instance in pgAdmin</div>
<div align="left"> </div>
<div align="left">I think that's the right name of the files for your version and you can find them in :</div>
<div align="left">C:\Program files\PostgreSQL\8.3\share\contrib</div>
<div align="left">or something corresponing on your system.</div>
<div align="left">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</div>
<div align="left"> </div>
<div align="left">But if you have the possibility you probably want to upgrade both database and postgis. Latest stable now is</div>
<div align="left">PostgreSQL 8.4.2 and PostGIS 1.4. Hopefully in a couple of weeks PostGIS 1.5 will be released.</div>
<div align="left"> </div>
<div align="left">Hope that helps</div>
<div align="left">Nicklas<br />
<br />
2010-01-13 Oscar Zamudio wrote:<br />
<br />
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 <span style="LINE-HEIGHT: 18px; FONT-FAMILY: 'Lucida Grande', Verdana, Geneva, Arial, Helvetica, sans-serif">SPATIAL_REF_SYS Table for example, or the GEOMETRY_COLUMNS table? </span>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? ></div>
<div>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</div>
</body>
</html>