Thanks to all.<div>Of course the template_postgis database was created when I installed PostGIS. And I used template_postgis to create my own PosGIS enabled database. I was not aware that there (postgis_template) I can find the tables I was looking for....</div>
<div>By the way my spatial application is working like a charm so everything it's ok. </div><div>Thanks again and regards,</div><div>Oscar<br><br><div class="gmail_quote">On Wed, Jan 13, 2010 at 8:28 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Oscar,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">The template database Nicklas is refering to is called
template_postgis.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">That always gets installed with the windows installer.
You can't uncheck it so no need to go back to install to get it. The test
database postgis that gets created is just a sample database. I personally
uncheck that setting.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">To create a new postgis database, you use the template_postgis
as the template. (instead of the default template1 )</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Its all outlined here</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"><a href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01" target="_blank">http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01</a>
(though note this one is for PostGIS 1.4)</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">There is no such table called <font color="#000000" size="3" face="Times New Roman">SPATIAL_GEOMETRY_COLUMNS .</font></font></span></div>
<div dir="ltr" align="left"><span></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">The tables are</font></span></div><div class="im">
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"><strong>geometry_columns</strong> and
<strong>spatial_ref_sys</strong></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
</div><div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">If you don't see those in your database or the below function
doesn't work, then you do not have postgis installed in your
database</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Courier New">SELECT postgis_full_version();</font></span></div>
<div dir="ltr" align="left"><span><font face="Courier New"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Courier New">As Nicklas said better to go with PostGIS 1.4.1, but if you
are using postgis 1.3.6, then the file is called lwpostgis.sql (instead of
postgis.sql (for 1.4 and upcoming 1.5))</font></span></div>
<div> </div>
<div><span></span><font face="Courier New">H<span>ope that clarifies things.</span></font></div>
<div><font face="Courier New"><span></span></font> </div>
<div><font face="Courier New"><span>Thanks,</span></font></div>
<div><font face="Courier New"><span>Regina</span></font></div>
<div><br></div>
<div dir="ltr" lang="en-us" align="left">
<hr>
<font size="2" face="Tahoma"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of
</b>Nicklas Avén<br><b>Sent:</b> Wednesday, January 13, 2010 9:08
AM<br><b>To:</b> PostGIS Users Discussion<br><b>Subject:</b> Re: [postgis-users]
Postgis installation<br></font><br></div><div><div></div><div class="h5">
<div></div>
<div align="left">How do you mean it is working well?</div>
<div align="left">If you have all the spatial functionality working you most
likely have :</div>
<div align="left">geometry_columns </div>
<div align="left">and</div>
<div align="left">spatial_ref _sys table<br>in your public schema.</div>
<div align="left"> </div>
<div align="left">But as I understood you, you have installed PostGIS with
stackbuilder but without creating the template-database. Then all nessecary
dll-files and sql-scrips is installed, but the database is not spatially
enabled. And that can be done as I described in last mail. That have to be done
for each new database that you want to use spatial functionality in. The
difference if you had installed the template database is that then you could
have spatially enabled a new database by using db postgis as template.</div>
<div align="left"> </div>
<div align="left">So</div>
<div align="left">Do you have a functional database with spatial functionality eg
st_distance, st_union and so on? or have you "only" installed postgis in the
server, yet.</div>
<div align="left"> </div>
<div align="left">/Nicklas</div>
<div align="left"> </div>
<div align="left"><br>2010-01-13 Oscar Zamudio wrote:<br><br>Thanks
Nicklas,></div>
<div>Maybe I did not expressed my questions very well. I already have a database
with PostGIS enabled and I am working well with it. I installed PostGIS 1.3.6 in
PostgreSQL as I mentioned using the App. Stack Builder. </div>>
<div>My problem is that now I want to check some PostGIS features as Reference
systems because I need to measure distances etc.. As I'm reading the manuals, I
learned about the existence of a SPATIAL_GEOMETRY_COLUMNS table (or example)
that I didn't find in my installation nor in my customer installation. I used to
see in another installation a database with the name "postgis" so I thought that
maybe in that database (that I guess is a master database for PostGIS extension)
I would find the tables that mention hte manuals. </div>>
<div>As I made a mistake in the original installation of PostGIS (didn't check
the creation of "postgis" database) I want to reinstall it and this time check
that option. How can I make this reinstallation and more important: can I do
this without affecting my own PostGIS enabled database I already created in
PosgreSQL? </div>>
<div>I certainly cannot update now to the last version of PostgreSQL and PostGIS
because my customer use this configuration and I don't want to push them now to
make these changes.</div>>
<div>Regards<br>><br>>>
<div>On Wed, Jan 13, 2010 at 10:33 AM, Nicklas Avén
<<a>nicklas.aven@jordogskog.no</a>> wrote:<br>> >
<div>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>
<div><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>>
<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></div></div><br>>_______________________________________________<br>>
postgis-users mailing
list<br>><a>postgis-users@postgis.refractions.net</a><br>><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br>
></div><br>></div></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br></div>