[postgis-users] How to dump a postgis table from one database to another

[Paul Ramsey]

You'll have to hand-enter the appropriate geometry_columns entry for 
your newly transferred table. Failing that, pgsql2shp, shp2pgsql will 
also work, though potentially with some mangling due to the limitations 
of shape format.

On Thursday, June 3, 2004, at 06:22 AM, Marcel Koopman wrote:

> Hello,
>
> I have this postgis table in a testdb database.
>
> I want to transfer it into my geodb database.
>
> I tried pg_dump but this doesnt work. It seems that the table pc4 is 
> not entered in the geometrycolumns table.
>
> So.. how do i tranfer the table?
>
> Thanks for you help.
>
> Marcel
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
      Paul Ramsey
      Refractions Research
      Email: pramsey at refractions.net
      Phone: (250) 885-0632