<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<title>RE: [postgis-users] HELP adding spatial field to table</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Book Antiqua";
panose-1:2 4 6 2 5 3 5 3 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0pt;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{margin-right:0pt;
margin-left:0pt;
font-size:12.0pt;
font-family:"Times New Roman";
color:black;}
pre
{margin:0pt;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.emailstyle18
{font-family:Arial;
color:navy;}
span.EmailStyle20
{font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body bgcolor=white lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=3 color=navy face="Book Antiqua"><span
style='font-size:12.0pt;font-family:"Book Antiqua";color:navy'> Question: </span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Book Antiqua"><span
style='font-size:12.0pt;font-family:"Book Antiqua";color:navy'> </span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Book Antiqua"><span
style='font-size:12.0pt;font-family:"Book Antiqua";color:navy'>I have two
development boxes both running PostgreSQL/PostGIS. On set-up several months ago
and the other today, the former has already had data loaded. I could fairly
easily move the Shapefile from one box to the other and then load but I know in
SQL Server I could connect to the other box and either use the data or move it
to the new database. Therefore, my question is does PostgreSQL offer similar
functionality? In other words, can you connect to other PostgreSQL machines? I
feel like Ive seen this via the command-line (pgsql) but not phAdmin. In either
case Im looking for help and confirmation. This more then just academically
interesting and could save a great deal of time. Thanks in advance.</span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Book Antiqua"><span
style='font-size:12.0pt;font-family:"Book Antiqua";color:navy'> </span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Book Antiqua"><span
style='font-size:12.0pt;font-family:"Book Antiqua";color:navy'>Regards,</span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Book Antiqua"><span
style='font-size:12.0pt;font-family:"Book Antiqua";color:navy'>Rich</span></font></p>
<p class=MsoNormal><font size=3 color=navy face="Book Antiqua"><span
style='font-size:12.0pt;font-family:"Book Antiqua";color:navy'> </span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
</div>
</body>
</html>