Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I try to use QGIS to display some data stored in PostGIS, some of the schemas don't show except public; and it's a testing database, so I have only one super user: postgres. I use PostgreSQL9.3.
Anyone has some suggestion?
I found the reason, it's because other schema is empty or there's no vector data inside. Previous I load a raster data into a schema named scratch
If you create a new database connection, you can check Only look in schema public, or leave it unchecked.
Only look in schema public
You can change this later if you edit the connection (unless there are no other schemas, then the entry is greyed out).
Required, but never shown