[postgis-users] Errors in loading table with geom which was produced with pg-dump

[Shaozhong SHI]

Hi, Raul Marin Rodriguez,

We are using PostgreSQL version 10.10 and postgis version 2.4.8 .

The command used for dump the data is pg_dump.exe.

The command used for import data is psql.exe.

The error message is full of invalid commands.

Regards,

Shao

On Thu, 23 Jan 2020 at 17:28, <rmrodriguez at carto.com> wrote:

> On Thu, Jan 23, 2020 at 6:23 PM Shaozhong SHI <shishaozhong at gmail.com>
> wrote:
> >
> > I used pg_dump to dump a table with from.  Then, I used psql to load it
> to another database, but it showed numerous errors.
> >
> > Why does that happen?
>
> Hi,
>
> You are not providing any information to debug the issue. The
> following information would help:
> - Postgresql and Postgis version of both the source and target database.
> - The command used to dump the data.
> - The command used to import the data.
> - The error messages.
>
>
> --
> Raúl Marín Rodríguez
> carto.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200124/f2f7593b/attachment.html>