Hello,
I am using ABP Suite in ABP Studio with PostgreSQL as my database. While trying to generate a page using the "Load Entity from Database" feature, I am unable to select the desired schema. The system does not provide an option to choose a schema other than the default one.
Could you please provide guidance on how to select a specific schema, or confirm if this is a limitation or a bug? If this is a known issue, do you have any planned fixes or workarounds?
Thank you for your support.
Environment Details:
ABP Version: 8.3.0
Database: PostgreSQL
Operating System: Windows
Best regards,
5 Answer(s)
-
0
Hi,
We'll check and respond you. Also I created an internal issue for this problem, we'll make an enhancement for this suite UI soon
-
0
Currently ABP Suite does not prompt you to choose a database scheme. Until we work on it, you can use the following workaround:
-
Create a backup/copy of your database
-
Move your scheme to the default scheme on your copied database
-
Create entities from that copy database
-
-
0
Hi,
I changed the default schema, but it didn’t work. Then, I removed the schema that was set as default. However, this time it ignored the other schemas and couldn’t find the tables.
-
0
I tried the same behaviour but unfortunately could not reproduce the problem. Are you sure the
public
schema has the tables? -
0
Can you try adding
currentSchema
parameter to your connection string?
https://jdbc.postgresql.org/documentation/use/#connection-parameters