topic Import features class to postgres database in Data Management Questions

Import features class to postgres database

EvanBlaisdell — Tue, 24 Mar 2015 15:04:10 GMT

When I attempt to import a feature class into my postgres database, it insists on looking for a schema named "postgres" and telling me "schema postgres does not exist." Ah, but I don't want to import into a schema named "postgres." I am connected to the database with my user name, let's say "myuser" and there is a schema called "myuser." Why does it insist on trying to find a schema "postgres"?

Re: Import features class to postgres database

JayantaPoddar — Tue, 24 Mar 2015 17:42:41 GMT

Hi Evan,

postgres is the schema of the superuser. You need to grant privileges of Geodatabase Administrator to "MyUser" as a "Postgres" user.

Thanks,

Jay

Re: Import features class to postgres database

Jeff_Demuth — Tue, 15 Mar 2022 18:12:51 GMT

This worked for me

create schema postgres;
grant usage ON SCHEMA postgres to postgres;