Select to view content in your preferred language

Import features class to postgres database

03-24-2015 08:04 AM
New Contributor III

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"?

0 Kudos
2 Replies
MVP Esteemed Contributor

Hi Evan,

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



Think Location
0 Kudos
New Contributor

This worked for me

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

0 Kudos