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.
- 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
takashi wrote:
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.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.