Category "postgresql"

How to convert UTF8 data from PostgreSQL to AL32UTF8 Oracle DB?

I have a task to import some data from Postgres database to Oracle via dblink The connection between Postgres and Oracle works good, but unfortunately, when I t

Referencing JOIN columns within a subquery from an aggregate function

I'm trying to reference columns in JOIN tables of a subquery from an aggregate function, as follows: WITH my_activities AS (SELECT activities.*, owner.*

Django cache real-time data with DRF filtering and sorting

I'm building a web app to manage a fleet of moving vehicles. Each vehicle has a set of fixed data (like their license plate), and another set of data that gets

How can I concatenate all values in descending order that have the same primary key in HIVE?

I am using HIVE and I have a table like this: S.no ID applicant_num f_name l_name Primary Key 1 123 202201A1 akhil yadav 123~&~akhil~&~yadav 2 123 2022

How to update local data from rxdb to server database postgrasql through graphql in react

we are trying rxdb as local database and postgresql as a server database and through graphql end point we are able to push and pull data from local to server an

Full text search failure on PostgreSQL

I have a PostgreSQL used to index text content. The SearchVector column is created successfully using the following code UPDATE public."DocumentFiles" SET "Sear

how to create a user in postgres to connect to nodejs?

It is my first time using postgres and I am trying to use it with node. I installed postgres in Ubuntu and created the user admin sudo -i -u postgres createuser

error in migration with legacy database in Django

I'm working on creating a filter in django where the options displayed are coming from a new column in the database. It turns out that this column was created d

JOOQ JsonbValue in where()

Working on trying to convert the following Postgres Query into Jooq. I would love to implement this with JOOQ's features instead of just copying the SQL in. Ult

Get the list of firewall rules on a Postgres Instance in Azure return empty in a azure function

I'm trying to get the list of firewall rules on a Postgres Instance in Azure, using the azure-js-sdk. Locally it works like a charm, I've got the list of firewa

Why can't my airflow webserver initialize properly?

When I create a dummy DAG following the Apache guide to airflow in Docker and run docker-compose up, the webserver container repeatedly fails and restarts with

How to fetch data in a given interval in postgresql

SELECT time,CEIL(AVG(value)) from table where col1 = 1 and col2='matchThis' and col3>='2022-04-10T18:30:00.00Z' and col3<='2022-04-25T12:58:2

PSequel not showing table content on my 2020 mac

first i create db in terminal, then i go to PSequel and add a connection with the local host. after i create my table in the query and refresh it, CREATE TABLE

How to separate tables based on the model using FSM and FSM-Log?

I'm currently logging status changes to several models in my Django REST API using the django-fsm and django-fsm-log packages. However, all of the logs are stor

Laravel - Method Illuminate\\Support\\Collection::makeHidden does not exist

I want to hide the columns password & OTP ,that is included in $uses result. Actually these 2 columns are part of the users table. I've tried like below. B

Process 'rumpostgreswk' running on linux and took 100% memory and CPU, where does it come from?

I have a question, I'm running a nodeJs server on a Digital Ocean droplet. I'm using pm2 for monitoring the application, everything looks fine. However suddenly

Can postgres insert triggers and/or check be ran without inserting

I would love to be able to validate objects representing table rows using the database's existing constraints (triggers that raise exceptions and checks) withou

Install Diesel error (3 errors) - failed to compile 'diesel_cli v1.4.1'

I'm trying to install database migration utility on my machine and run into multiple errors when trying to run in Powershell. Postgres 13 running I've installed

Create Postgres Docker Image with Database

How to Create Postgres Docker Image with Data? I have this folder/file structure: - initdb - 01-createSchema.sql - 02-createData.sql - Dockerfile The Docke

How to reset password in postgresql (psql) for particular role in case when I list the role name it is not exist?

I have installed PostgreSQL for a long time but just currently learning it. Here is what happened if I run psql in the command prompt C:\Users\VandaRsq>psql