I have Postgres16.1 running in a container in Docker Swarm, alongside inter alia Promtail, Loki and Grafana. I want to direct Postgres logs in JSON format towards Promtail for easy processing in Promtail pipeline stages (especially of multiline logs). The…
I have a problem here which i believe it has 2 solutions. Here is my first implementation with function overloading: type PostgresConnectionOptions = { dialect: "postgres"; config: pg.PoolConfig; }; type MysqlConnectionOptions = { dialect: "mysql"; config: mysql.PoolOptions; }; type SQLiteConnectionOptions…
so I have two tables as shown TABLE A CrimeType CrimeSubType Neighborhood Year 1 1 Jeff Park 2024 2 2 Cong Park 2023 2 2 Cong Park 2024 2 2 Jeff Park 2024 3 1 Jeff Park 2024 3 2…
Postgres SCD Type 1 program updating all rows instead of only to those matching rows, those unmatched row will be updated as blank. -- Create table tableToBeUpdated CREATE TABLE "TEST"."TABLETOBEUPDATED" ( "Z" character varying(5), "ID" integer, "Y" integer ); --…
in the following query i want to search on both name and agreementNumber but in OR mode, if name or agreementNumber matches then find but it is not working like this async findAll(filter: DataFilterDto): Promise<ApiResponseDto> { const take = filter.count…
I have a PostgreSQL (v15) DB view that rolls up a bunch of data per user for a single organization, to display a report of data like fees owed/paid per user, etc. This is executed with an org ID and…
I don't have much SQL knowledge, so I need some help. I'm using Prisma ORM and have two tables there, Jobs and Payments: Jobs: enum JobTypes { VISUAL_IDENTITY BRAND_DESIGN PACKAGING_DESIGN UI_UX NAMING ILLUSTRATION PHOTOGRAPHY VIDEO_FILMING AUDIO_SOUND OTHER } enum JobStatus…
I'm trying to create 3 arrays, iterate through each, and insert records depending on the value of those iterations. My code is as follows: do $$ declare days integer[]; times time[]; durations integer[]; begin days := array[1,2, 3, 4, 5,…
I'm trying to change default port and host for psql. I added PGHOST and PGPORT to /etc/bash.bashrc and I can echo them and ping my remote db_host server: $ echo $PGHOST db_host $ echo $PGPORT 19000 $ ping db_host PING…
I have a request to add new column that will count distinct column named kode_buatan from january to the month in the record (so if the record have date in march 2024 count distinct kode buatan from january 2024 to…