<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Great, thanks to you both.<br><br>Stephen R. Crawford<div>Center for Environmental Informatics</div><div>The Pennsylvania State University</div></div><div><br></div><div><br>On Oct 14, 2014, at 8:58 AM, Ben Madin <<a href="mailto:ben@ausvet.com.au">ben@ausvet.com.au</a>> wrote:<br><br></div><blockquote type="cite"><div><div dir="ltr">If you mean from one postgis database to another postgis database I think you will find pg_dump most helpful using the -t flag for the table you want.<div><br></div><div>If they are both on the same cluster:</div><div><br></div><div>pg_dump -t myTable myDatabase1 | psql myDatabase2</div><div><br></div><div>(caveat is make sure that the second database has postgis extension installed first)</div><div><br></div><div>Otherwise, dump to a file </div><div><br></div><div>pg_dump -t myTable myDatabase1 | gzip -9 > myTable.sql.gz</div><div><br></div><div>unzip and reload into second database.</div><div><br></div><div>cheers</div><div><br></div><div>Ben</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 14 October 2014 00:45, Stephen Crawford <span dir="ltr"><<a href="mailto:src176@psu.edu" target="_blank">src176@psu.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello All,<br>
<br>
I want to copy a postgis table from one database to another. Is dumping to a shapefile the best way to do this? Any other method? Pros and cons?<br>
<br>
Thanks,<br>
Steve<span class="HOEnZb"><font color="#888888"><br>
<br>
-- <br>
Stephen Crawford<br>
Center for Environmental Informatics<br>
The Pennsylvania State University<br>
<br>
<br>
______________________________<u></u>_________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-<u></u>bin/mailman/listinfo/postgis-<u></u>users</a><br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><br>Ben Madin<div>BVMS PhD, MANZCVS<br><br>t : +61 8 6102 5535<br>m : +61 448 887 220<br>e : <a href="mailto:ben@ausvet.com.au" target="_blank">ben@ausvet.com.au</a><br><br>AusVet Animal Health Services<br>Western Australia<br><br><a href="http://www.ausvet.com.au/" target="_blank">www.ausvet.com.au</a><br></div></div>
</div>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>postgis-users mailing list</span><br><span><a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a></span><br><span><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></span></div></blockquote></body></html>