<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Baris,<br>
<br>
It could be just that the file is not located in the current
directory. It has been a while since I have manually installed a
Postgres/PostGIS install, but in our installs it appears to typically
reside in the contrib/postgis-.../directory.<br>
<br>
You can try doing `locate postgis.sql` on your machine to find exactly
where it is.<br>
<br>
psql -d mydb -f [full path to postgis.sql] should do the trick for you.<br>
<br>
--Adam<br>
<br>
Baris YILMAZ wrote:<br>
<blockquote cite="mid20060113180650.21386.qmail@web52409.mail.yahoo.com"
type="cite">
<div id="RTEContent"><br>
Hi,</div>
<div> </div>
<div>I am new to postgresql and postgis. I installed postgresql ver
8.1 (windows version) to my computer. I read on the web site that, this
also includes the postgis extension. Now, I have a problem. Using the
ms console, I created a testdatabase, called mydb which has
plpgsql features (with <font face="Arial">createlang plpgsql [dbname])</font></div>
<div> </div>
<div>Then, I try to load the postgis tools, with the command, </div>
<font face="Arial"> </font>
<div align="left"><font face="Arial">psql -d mydb -f postgis.sql</font></div>
<font face="Arial"> </font>
<div align="left"><font face="Arial">But i get the error message, </font></div>
<font face="Arial"> </font>
<div align="left"><font face="Arial">postgis.sql: No such file or
directory</font></div>
<font face="Arial"> </font>
<div align="left"><font face="Arial"> </font></div>
<font face="Arial"> </font>
<div align="left"><font face="Arial">Can anyone tell me why? In the
documentation, it is written that, postgis.sql is included in the
installation of postgis, which is in the postgresql ver 8.1 included.
But it can't find this file.</font></div>
<font face="Arial"> </font>
<div align="left"><font face="Arial">Any help will be appreciated. </font>
<div align="left"><font face="Arial">Thank you in Advice</font></div>
<font face="Arial"> </font>
<div align="left"><font face="Arial">Baris</font></div>
<font face="Arial"> </font>
<div align="left"><font face="Arial"> </font></div>
<p> </p>
<hr size="1">Yahoo! Photos<br>
Ring in the New Year with <a
href="http://us.rd.yahoo.com/mail_us/taglines/photos/*http://pa.yahoo.com/*http://us.rd.yahoo.com/mail_us/taglines/photos/evt=38087/*http://pg.photos.yahoo.com/ph//page?.file=calendar_splash.html&.dir=">Photo
Calendars</a>. Add photos, events, holidays, whatever.
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</div>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Adam Quiney
Analyst
Refractions Research Inc.
(250) 383-3022
</pre>
</body>
</html>