Open Closed

ABP Suite - PostgreSQL Schema Selection Issue in "Load Entity from Database" (v8.3.0) #8835


User avatar
0
can-hs created

AbpSuite.png

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)
  • User Avatar
    0
    enisn created
    Support Team .NET Developer

    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

  • User Avatar
    0
    enisn created
    Support Team .NET Developer

    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

  • User Avatar
    0
    can-hs created

    image.png

    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.

  • User Avatar
    0
    enisn created
    Support Team .NET Developer

    I tried the same behaviour but unfortunately could not reproduce the problem. Are you sure the public schema has the tables?

  • User Avatar
    0
    enisn created
    Support Team .NET Developer

    Can you try adding currentSchema parameter to your connection string?
    https://jdbc.postgresql.org/documentation/use/#connection-parameters

Boost Your Development
ABP Live Training
Packages
See Trainings
Mastering ABP Framework Book
Do you need assistance from an ABP expert?
Schedule a Meeting
Mastering ABP Framework Book
The Official Guide
Mastering
ABP Framework
Learn More
Mastering ABP Framework Book
Made with ❤️ on ABP v9.2.0-preview. Updated on March 19, 2025, 10:09