I'm storing time-series data of some products to my DB server. Ubuntu 20.04 LTS PostgreSQL 15.x SSD: 5TB with RAID 5 (OS and Postgres installed) HDD: 6TB with RAID 5 (my target of data migration) As data comes in, it…
I've got a simple array of IDs and need the query to reply with the same order the query SELECT id, title FROM pages WHERE id = ANY(ARRAY['6e3e4470', 'fec27534']) the result id title fec27534 2020 6e3e4470 2022 as you can…
I want to make a prepared statement for a query that takes a number and calculates an interval. Something along these lines: SELECT col FROM t1 WHERE createtime < (NOW() - INTERVAL ? DAY) However, this doesn't work, because the…
I'm looking to copy a PostgreSQL Server to Another server. I want to migrate entire server which might contain multiple databases I am trying to do it with cloud databases (e.g. AWS which doesn't provide super user privileges for RDS)…
I have the task of finding all unique data types in all the tables. This is how I wrote the SQL query: WITH UniqueColumnTypes AS ( SELECT table_name, COUNT(DISTINCT data_type) AS unique_types FROM information_schema.columns WHERE table_schema NOT IN ('pg_catalog', 'information_schema')…
In Apache AGE, when I call the DirectFunctionCall() function. It doesn't get executed. I have tried putting logging statements using elog() function in the write() function. But, it's of no use. The code sample is given below - PG_FUNCTION_INFO_V1(some_function); PG_FUNCTION_INFO_V1(write);…
In a Postgres db, I have a view called school_id_cards. The view captures a list of id cards per school and student in a school system. ID cards are periodically reissued to students, so there may be any number of…
I have a situation where I need to insert data into two tables, where the inserted data is derived from the same long sub query. I know that CTEs can be helpful in similar situations since you can define a…
Trying to make use of the official postgres docker image with: docker run --rm -d --name my-postgres --network my-network -e POSTGRES_USER=postgres -e POSTGRES_PASSWORD=mysuperduperlongpwstring -e POSTGRES_DB=postgres -v /path/to/postgres/data/:/var/lib/postgresql/data postgres However, when creating postgres connection with Go, psqlInfo := fmt.Sprintf( "host=%s port=%s…
I'm trying to add a postgres server to pgadmin4, through bash commands in a docker compose file. Here's my docker compose file: version: '3.9' services: podcast_db: image: postgres:15.3-alpine container_name: podcast_db ports: - 5432:5432 volumes: - podcast_db_data:/usr/share/podcast_db/data env_file: - ./database/.env.local.db #…