Support postgresql schemas

[Neyri]

Hello,
Thanks for the great tool 😄

I'm currently working with a postgresql database and I would like to make use of postgresql schema feature.
I think it would be nice to add another attribute to postgresql tables called schema (defaulting to public) and add a color differentiation between tables in the same schema

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[dineug]

Do you mean that function?
https://docs.erd-editor.io/docs/guide/guides/table-related-functions#table-memo-color-specification

[Neyri]

Not really. In postgresql there's a layer between databases and tables called schemas (see here). For instance, you can have a database db with 2 different schemas and several tables in each schema (unique table names are defined per schema and not per database). So my suggestion would be the ability to select a schema associated with a table

[dineug]

Currently, we are developing the functionality assuming one schema per file as a default, and changing that principle would be a challenging decision. We are not considering vendor-specific features at the moment.