I have a table and want to replace the column value with value from other column value based on some condition. +---------------------+ | Cntry | Code | Value | +---------------------+ | US | C11 | A | | US |…
I have JSON stored in a jsonb column: [ { "ORDER_TYPE": "foo", "PAYMENT_TYPE": "VISA", } ] I can query fine but is it possible to select specific parts (PAYMENT_TYPE) of the json from the resultset? SELECT PAYMENT_TYPE FROM tools.orders WHERE…
Suppose i have the following model: from django.db import models from django.contrib.gis.db import models as gis_models class Place(models.Model): location = gis_models.PointField(geography=True, srid=4326) Later i am performing the search on those Places; my query is "fetch all places no further N…
I have a dump file (size around 5 GB) which is taken via this command: pg_dump -U postgres -p 5440 MYPRODDB > MYPRODDB_2022.dmp The database consists multiple schemas (let's say Schema A,B,C and D) but i need to restore only…
Is the database used by netbox PostgreSQL? Our virtual machine base information is stored inside netbox. We need Java to go to netbox to create VM information and to get VM information. But this does not guarantee transactivity. So we…
I have a text field on my PostgreSQL database that I want to store only capital alphabetic letters not but not special characters in a column. I have already used CHECK (location_id ~* '[A-Z]') I am able to insert both…
Need to find the sequential difference and average between within a columns of two rows group by brand column and order by bill_id column and find the difference of worth column between rows in a single query. I have a…
For the following tables: -- People id | category | count ----+----------+------- 1 | a | 2 1 | a | 3 1 | b | 2 2 | a | 2 2 | b | 3 3 | a…
I am trying to get data from a jsonb column and need to cast an attribute from the payload to timestamp. But the query aborts when the value is null or invalid. This is my select statement. Select (jsonb_path_query(AnchorNode, '$.TestDate')#>>…
Are there other special literal values besides NULL in SQL / PostgresQL? NULL is nice in that we can interpret NULL as the concept of "nothing" (i.e. missing, not available, not asked, not answered, etc.), and data columns of any…