I know this has been asked previously but I am spinning in circles here.... I have a postgres 14 database and a Springboot application running flyway-db:7.13.0
I'm working on a google calendar kind of repeat feature using angularjs/php. Trying repeat the event for every 2 weeks on multi selection of days and that even
create index if not exists employee_index on employee(emp_id, (emp_first_name|| ' ' ||emp_last_name)); I'm able to use the above statement in Postgres, I w
Initially let me explain the whole situation. The database is Postgres 13. I need a "dynamic selection" In the first place... The tables I work with have many c
I'm using AWS DMS 3.4.6 to migrate a PostgreSQL 13.6 database to another PostgreSQL 13.6 database, both in AWS RDS. One particular column in my database is a ti
Given two time-series tables tbl1(time, b_value) and tbl2(time, u_value). https://www.db-fiddle.com/f/4qkFJZLkZ3BK2tgN4ycCsj/1 Suppose we want to find the last
I want to get my sales for each day which is located in my orders_summary table. orders_summary table columns: id, date, amount, sku_id products table columns:
I can't connect on postgresql. when i go on pgadmin>server>postgresql, it asked me "please enter the password for the user 'postgres' to connect the serve
How to identify the total size of the db (Used) and the total size of the db. for the total size of the db (Used) : pg_database_size('dbName') cmmnd works. But
I have the simplified version of the table I have below. Each row has an item_order value partitioned by its parent_id. item_id item_name parent_id item_order
Does any one know how to create crosstab queries in PostgreSQL? For example I have the following table: Section Status Count A Active 1 A
I have table booking with below records. event_type | from_date | to_date -------------+---------------------+--------------------- party
As part of a standard laravel application with a vuejs and axios front-end, when I try to save an ISO8601 value to the action_at field, I get an exception. clas
I have response query like below dest emp 893106 0 717205 1 888305 0 312301 1 645100 0 222001 0 761104 1 And I want to get window function to separate rows li
I'm getting this error trying to replicate a postgre database (not RDS) to another postgre database (also not RDS). I get this connection error but the endpoint
I need to move table from aws data catalog to the schema which i created in aurora postgresql instance. I tried this using glue job. I have created connection f
In an effort to power an autocomplete, I resolved to map a PostgreSQL view. I followed a tutorial for this. It seems that it does not work at all : I've always
When I am trying to insert a record into Postgresql I am getting below error. pg8000.exceptions.DatabaseError: {'S': 'ERROR', 'V': 'ERROR', 'C': '42601', 'M':
I enabled uuid extension with CREATE EXTENSION IF NOT EXISTS "uuid-ossp"; Then ran same query generated by sequelize for migration and it worked, create table i
I have enabled Query Performance Insights, however, the Query Text fields are left empty, as you can see from the screenshot below. I have enabled the Query St