Copy query for postgresql is not right

wappler 5.2.1

thank you for finally adding the copy button on auto-gen query shown on query builder modal.

for postgresql, the copied query has all the table names in double quotes when schema name is not ‘public’.

e.g.
select * from "app.m_user"
this is not a valid query, following is:
select * from app.m_user
(without the double quotes around the table name)

can this be fixed up please.

thank you.

This works correctly if you enable experimental features.

thanks. i checked.

the " are removed with exp mode on
but
in the FROM table, the schema name is there (in our case ‘app’): app.my_table
but for all the joined tables, this schema declaration is missing, it just reads: other_table, third_table and so on.

schema decleration should be on all table names please.

Fixed in Wappler 5.2.2

This topic was automatically closed after 47 hours. New replies are no longer allowed.