I have a large table(117 899 162 rows) the query below is very slow but if I remove EXTRACT(ISODOW FROM l2.starttime) IN (1) the performance is alot better. I g
So we have a new project where we need to use postgres 14 to scale up a transaction table that gets heavily updated. The Master table has about a 60 million row
I need to execute a complex query for testing purposes with params. How to write a SELECT query which can be executed in DataGrip / PgAdmin with params: EXECUTE
Im working on postgraphile server. the stack is: nodejs, expressjs, postgraphile and knex. My auto-generated graphiql exposes queries to tables it doesn't need
I'm trying to query data to bigquery with this code as mentioned in google docs: from google.cloud import bigquery client = bigquery.Client() tab = client.query
In PostgreSQL, I have a table as follow. | id | mycolumn | | -------- | -------------- | | 1 | /1/2/8/ | | 2 | /1/40/22/11/ |
I have been working over jsonb columns in postgresql. My problem statement is to store array of json objects, so i thought of jsonb[] datatype as it is a viable
After adding OneToMany and manyToOne relations in the entities and doing GET request it shows in postman 500 error. // Car entity @Entity({ name: 'car' }) expor
In this query, I'm listing all users in organization 123 but I also want a column showing which other teams they are on across all organizations. My query right
Table flights: ID Path 1 NZ:EU 2 JP:CA SELECT path FROM flights WHERE path ILIKE '%' || 'jpca' || '%' Above query isn't working, it needs to retu
I am using typeorm with postgresql. I want my auto incremented primary key column to start from specific initial value instead of 1. Is there any solution in ty
I have data in my timescale database. If we only look at the "time", everything is fine. But if we look at the "id" we can see that 152 and 153 numbers didn't s
There are two tables, one is called "user_preference" that contains all users: id | firstname | lastname | email | And "match" which combines users with meetu
I am using the code below to create a function with variables that updates a jsonb column with a json object or create it if it doesn't exist - With help from
I have a query which returns next table with name first_table: Name ID First 1 Second 2 And I need to join another table named second_table: ID ParentID 22 1
I have a table with a starting time, finishing time and delivery columns. The starting and finishing times are of the timestamp without time zone data type (YYY
I'm using StreamSets and will soon need to load data from fixed length file and packed decimal (cobol comp-3) to insert into Postgres to regular number numeric(
I am using pg_sym_decrypt/encrypt to decrypt/encrypt some of the fields in my table. Decryption happens on select in a separate EntityComputed view that has a o
Thanks for reading my post. I wanna know, what is the difference between length (1-256) and (0-256) in sql and how to store them in database?. I was asked to de
I’m using Jhipster (Gradle + React) for one of my project, and recently, I want to add Multi-tenancy support to the whole application (tenant will be the