CODEWITHSUNDEEP
sqlpostgresql
Sahil Dhawan
Sahil Dhawan

Reputation: 91

Error: 'no schema has been selected to create in' even though search_path of schema is set

I'm new to postgreSQL.
After creating user sahilfile and conecting to database pfile, I had created schema pschema1. I have to create table ptable1 in pschema1, for which I applied the required search_path syntax.
However I came across the error mentioned above even though on applying show search_path;I'm in pschema1.
How could I resolve this issue?

Edit: On using create table pschema1.ptable1( .. ), it says pschema1 does-not exist- even though it's visible in pgadmin III.

Upvotes: 1

Views: 9298

Answers (1)

user3544913
user3544913

Reputation: 81

Try using quotes while using the schema. Using this way, "pschema1".ptable1 works for me.

Upvotes: 1

Related Questions