[Screenshot 2023-08-05 at 4.33.09 AM] I have written this query, which updates a table view as per my ListView (this is also dynamically generated) however when the query is executed, CompanyData is getting converted to companydata. [Screenshot 2023-08-05 at 4.35.27 AM] As you can see, it show…

If your table is not in the schema public or the proper default schema hasn't been set for the user, then you'll need to include the schema name in your query. That is what the error implicates, it can't find the table (in the schema). Postgres objects tend to be case insensitive by default, so it s…

Dynamic SQL Query automatically converting to lowercase

💬 Queries and Resources

rakshit087 August 5, 2023, 8:47am 4

I have already disabled the prepared statements, the thing is the list of tables is dynamic in nature so the names are not predefined.

Table names are contained in a central table

Topic		Replies	Views
Dynamic table name in query 💬 Queries and Resources sql	9	5580	August 2, 2023
FROM database_name as db >>> FROM {{select_table.value}} as db 💬 Queries and Resources	8	1310	August 3, 2023
How to create a dynamic query without changing resource settings? 💬 Queries and Resources sql	10	6999	August 3, 2023
Select from a different table depending on string interpolation 💬 Queries and Resources sql	2	172	September 9, 2024
My Query is working in MySQL, but not in Retool 💬 App Building	9	465	July 25, 2024

Dynamic SQL Query automatically converting to lowercase

Related topics