How to return a multiple tables result in stored procedure or function in PostgreSQL? I need to return multiple tables result set in PostgreSQL and fetch the details in Nest.JS Application, Can any one explain on this work?
I have a Docker container serving a Postgres database on port 5432. I am now attempting to build another container that uses the Prisma Client to access the database. However, to be able to build the project I first need…
If I use the statement SELECT * FROM dump WHERE (x_orig IS NOT NULL) OR (x_dest IS NOT NULL); It does not filter out the null values in the columns I indicate. But when I use the statement SELECT *…
I am new at Postgresql that's why I can't figure out some privileges here. Database called Denemedb23 is already created. I created the user NoxUser. I executed these commands: REVOKE ALL PRIVILEGES ON DATABASE Denemedb23 FROM public; GRANT CONNECT ON…
Recently, our users have been complaining about the sometimes very long loading times of our web application. This occurs both when reloading the page and when using the page. all users are affected at the same time. Sometimes everything runs…
Database aggregation is usually much faster than returning all the data to the application and calculating there. But for this partitioned table, a simple one-column AVG() query runs in 15 seconds, while returning all the rows to the application runs…
I have a spring framework web application and I'm trying to deploy it into production using tomcat with docker image. I searched about this error and found out there are two possible errors. The first one is incorrect database url…
How to find sequence of Alphabets of non-ASCII (other languages) in a given string in PostgreSQL? For example, ASCII alphabets can be matched using '[A-Za-z]'. In SQL Server, @ch BETWEEN 'A' and 'Z' matches the characters like Ñ, ü, Ä,…
I have sample XML files, where i need to ready Node name & create table name similar to Node name skipping container nodes. Then read these XML Nodes and create Dynamic table with dynamic columns in Postgres sql Script file.…
Say you want to optimize a query in a postgres database like: SELECT DISTINCT ON (first) first, second, third FROM my_table WHERE second > 100 AND fourth = 3 ORDER BY first, second DESC, third DESC (EDIT: In this example,…