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.
Solved
why I can not create a new table to Postgis
- Participant
Best answer by takashi
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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- Best Answer
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.
- Participant
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.
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.