schema support?

[swuecho]

I can 'set search_path= schema' and run the query through the browsers, but the tables names show in the left do not change.

thanks.

[cbandy]

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.

[alibitek]

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.

[cryptix]

👍

[dmelamedcl]

👍

[jars]

👍

[cjthompson]

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.

[jerome-peng]

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.

[jerome-peng]

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

[gglanzani]

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

[alfonsodev]

👍

[dreuse]

👍 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.

[sosedoff]

hang tight, im working on it.

[alfonsodev]

👍 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. :)

[brian-vogogo]

👍 Would like this schema support. Willing to help.

[sammcj]

+1

[sosedoff]

Implemented in master