schema support? about pgweb HOT 16 CLOSED

I think we should support multiple schemata. The simplest approach would be to show all of them all the time.

Something nicer may be to show those for which the current user has USAGE privilege. This could change with a SET ROLE statement, so maybe a button to refresh on demand.

Basing the list on search_path also makes a lot of sense. Again, this could change, so a refresh button may be appropriate.

from pgweb.

This is an important feature, it is very rare in my experience that I see tables in the default public schema.

Usually they are in different schemas with different security definers / policies in place where everything in public schema is the API.
Everything else (tables, internal functions, triggers, views, etc.) is visibile only to a particular user or group of users that are connecting from the backend service to a certain schema name.

from pgweb.

👍

from pgweb.

👍

from pgweb.

👍

from pgweb.

I just ran into this problem also. My database doesn't use the public schema, so I can run queries but cannot select any tables.

from pgweb.

yeah,I just ran into this problem also. My database doesn't use the public schema, so I can run queries but cannot select any tables.

from pgweb.

Does this proble solved?
I use pgweb_windows_386 version 0.5.0, schema support?

from pgweb.

Is this also the reason why I cannot see materialized views?

from pgweb.

👍

from pgweb.

👍 I just ran into this problem also. My database doesn't use the public schema, so I can run queries but cannot select any tables.

from pgweb.

hang tight, im working on it.

from pgweb.

👍 if you want help push the branch with your progress or your idea how would you like to implement it,
I really would like to see this feature, wouldn't mind to help.
thanks for your effort! I use this tool every day. :)

from pgweb.

👍 Would like this schema support. Willing to help.

from pgweb.

+1

from pgweb.

Implemented in master

from pgweb.