I'm building a WinForms project in C# using a PostgreSQL database and the Npgsql framework. For inserting a record, I need to return the ID of the new record.
I am aware that I can connect to a pre-configured Digital Ocean PostgreSQL database cluster and that's what I'm actually connected to right now, but I'd like to
I want to use below query in TypeOrm but can't find a way to convert it to TypeOrm. Any help is appreciated. SELECT * FROM blocked_times bt LEFT JOIN LATERAL
I need to make a script that make a replacement of all the registers of a column that contains: '@xxxx', removing the single quotes. (xxxx could be empty or any
I am trying to use the R function from a R package (https://cran.microsoft.com/snapshot/2017-04-03/web/packages/genasis/index.html) directly in Postgres without
Below the Entity trying to persist : @Data @Entity @Table(name = "REQUEST") @TypeDef(name = "jsonb", typeClass = JsonBinaryType.class) public class Request { @
Suppose we have these two tables. TABLE1: |column_1 | ... | -------------------- | 'a' | ... | | 'b' | ... | | 'c' | ... | |
I have a native Query that return a list of objects, i need to pass an array as parameter to the function getAllUsers. @Repository public interface UserReposito
What I've read here doesn't quite answer what I'm trying to do. That's why I'm posting a request here and I'm confident to learn what I can do on this subject.
i fight with same issue as described here: Slow connection PHP PDO Postgres but not MySQL here's the thing - PDO Postgresql connections seem to be really slow
I would like to create ERD from my Heroku PostgreSQL database? How can I generate ERD? Is there any external tool that will help with this? Can you use Dbeaver
I'm using Supabase as a database and trying to implement a full-text search. My example setup is quite simple, I have two tables: items +----+-----------+------
I have tried to search other questions, but the solutions arent cutting it. I have a java spring boot application running inside docker, using the command below
I would like to create ERD from my Heroku PostgreSQL database? How can I generate ERD? Is there any external tool that will help with this? Can you use Dbeaver
How can I use Custom Column feature in Metabase to cast column from Text to Integer for sum calculation.
I have recently installed PostgresSQL and my servers are just empty. I am sure I should have servers under servers and a database to play with but I have nothin
I have been trying to add Row Level Security to Superset and I have written this clause: when I hard code this clause in a select on the database it works as i
I´m doing an Spotify clone and I´m trying to add a song to a playlist but my query doesn't work, until this point, everything was good following the
I am using Postgres as a service in my docker-compose file. I want logging to log file to be enabled when I do docker-compose up. One way to enable logging is b
I have a PostgreSQL database with Sequelize ORM and I want to listen for new entries. How should I do? Should I use Sequelize afterCreate hook? Can someone help