Skip to main content
  • EN

Hi,


When I would like to insert a new table to Postgis, I am getting below error. For existing table is ok. Its means that, it is inserting a new records, but if does not exist table, it does not allow to create.

Hi @esaka, most likely the error message "Schema 'gis' is not a valid schemaname" indicates that the schema 'gis' within which you are going to create a new table does not exist in the destination database. Firstly check if the schema exists, with pgAdmin. The pgAdmin is a convenient tool to manage PostgreSQL/PostGIS databases.

Hi @esaka, most likely the error message "Schema 'gis' is not a valid schemaname" indicates that the schema 'gis' within which you are going to create a new table does not exist in the destination database. Firstly check if the schema exists, with pgAdmin. The pgAdmin is a convenient tool to manage PostgreSQL/PostGIS databases.

Thankyou Tahashi,

 

There was no schema as "gis". Actually, gis was my database name.

 

I was trying to insert to "public" shame. However, I created a new schema as "gis" and it did.

 

Thank you again.

 

 

Reply


Community Stats

30,108
Posts
114,294
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.