Skip to main content
1,830 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
60 views

I'm using Sequelize v6.37.5 with PostgreSQL in a multi-tenant architecture, where each tenant has its own schema. Models are defined once globally, and we use .schema(schemaName) to access tenant-...
DIGVIJAY SINH CHAUHAN's user avatar
  • 1
0 votes
0 answers
80 views

I have worked with Microsoft SQL, and it was very easy to find the tables and stored procedures that were being called when an event occurred in the application. It helped a lot in identifying the ...
Adish Krishnan's user avatar
  • 1
1 vote
1 answer
155 views

I have two owners in my postgresql database e.g. testdb, I have some tables of owner1 and some tables of owner2. I am facing issue in setting replica identity full for tables of owner1 using owner2 ...
Neeraj Kumar's user avatar
  • 11
1 vote
1 answer
363 views

I am trying to create a native query using spring JPA for the below query. I am trying to filter the data where the jsonB contains the filtered key. select * FROM targeted_event_catalog e WHERE e....
Koushik J's user avatar
  • 672
0 votes
1 answer
80 views

I have two tables. table 1 Column A Column B rgz 1 dry 1 vgy 2 chy 3 pom 2 table 2 Column C Column D tuv 10 tuv 11 chx 22 lmn 34 I want the following result shown on data output of postgres PgAdmin ...
G Nisan's user avatar
  • 3
1 vote
0 answers
39 views

I have a log table in which I keep user login records. CREATE TABLE public.login ( id bigint NOT NULL, copy_id bigint, create_date timestamp without time zone, version integer NOT NULL DEFAULT ...
Yusuf İncesu's user avatar
  • 11
0 votes
2 answers
336 views

I'm maintaining an old PostgreSQL-based application (PostgreSQL 9.1.22) on a Windows 2012 Server and we have noticed some data integrity inconsistencies. No errors have been spotted in logs nor in the ...
Claudi's user avatar
  • 5,436
0 votes
0 answers
91 views

Azure DB for Postgres flexible server I have Azure DB for Postgres flexible server. I have created a database in this server with en_US.utf8 collation. In this database I have created a table with ...
P Suresh's user avatar
  • 1
0 votes
1 answer
50 views

const response = await OrderDal.findAll({ where: { buyerId: userId }, attributes: { exclude: ['outcomeId', 'programId'] }, include: [ { model: User, as: 'buyerOrders', ...
Numaira Nawaz's user avatar
  • 31
0 votes
1 answer
45 views

I have a query in mysql, trying to convert to Postgre, I could not find 'information_schema.STATISTICS' equivalent in Postgre. Is there any way to achieve in Postgre. Full Query: SELECT t.TABLE_NAME ...
vasu's user avatar
  • 171
0 votes
2 answers
306 views

In mysql when I enter the following mysql -u root -p Password: enter password successfully I then get into my local server and from here I can view all my databases using SHOW DATABASES. But when I ...
Bop 1ABot's user avatar
  • 29
0 votes
1 answer
611 views

I have a project on Supabase and I've wanted to implement TCE to encrypt a certain column. I am running into errors when trying to insert into my table which has an encrypted column. Here is my table ...
sumato's user avatar
  • 40
0 votes
0 answers
17 views

I have an error with code 'ON CONFLICT' when I use PostgreSQL with version 9.1.11
Shabrina Nurdiani S's user avatar
  • 49
0 votes
2 answers
92 views

Is postgresql can do average for rolling data? I have this case where I need to average the values for 5 days and get all the days filled up while waiting for the actual values so basically if I'm in ...
pottttttossss's user avatar
  • 91
1 vote
1 answer
212 views

I want to extract data from json and put into columns. create table mytable (id integer,data jsonb); insert into mytable (id,data) values(25,'{"_id":25,"indicator 1":"yes&...
sahil's user avatar
  • 119
0 votes
1 answer
236 views

I have three tables Customer, Product and Transactions. I have used Elastic Search to build index joining the three tables. The output of the index looks something like this { "customer_id&...
DarkKnight's user avatar
  • 3
0 votes
1 answer
119 views

I have a table and multiple rows in it.I want to increment rows of port column by 1 which is above certain range.(this certain range i am getting from another query) I tried using row_number() over() ...
snehapriya katikala's user avatar
  • 25
1 vote
0 answers
410 views

I am trying to do CDC using debezium on postgresql. I ran the following docker images > ZOOKEEPER docker run -it --rm --name zookeeper -p 2181:2181 -p 2888:2888 -p 3888:3888 quay.io/debezium/...
Sai Ram's user avatar
  • 4,442
3 votes
2 answers
1k views

I'm trying to create a new user in postgresql which have read only access to Databases. I followed this document I will just list out the commands I used CREATE ROLE readaccess; GRANT CONNECT ON ...
Alexy Pulivelil's user avatar
  • 177
0 votes
2 answers
85 views

I have a table ,one of the table filed is json format: my_table id json_field 1 { "to_status": 7, "to_status_name": "In Progress", "role": "admin"...
William's user avatar
  • 4,094
1 vote
0 answers
595 views

I tried using the code below to add two foreign keys to the table products but it wont add foreign keys if i run the two on one run, they work individualy but not if i code it the way below: ALTER ...
Davie's user avatar
  • 11
1 vote
0 answers
112 views

While dropping constraint named 123_5_pk_not_null, I am getting syntax error at the start of constraint name. Query: alter table table_name drop constraint 123_5_pk_not_null; Error: Syntax error at ...
krishna raja's user avatar
  • 11
0 votes
1 answer
1k views

I'm using a Linux server, I want to upgrade postgresql from the version 9 to 11. I have created a dump of my database. Then I have installed postgresql 11, now I want to import the dump to postgresql ...
mourad semi's user avatar
  • 47
1 vote
1 answer
87 views

I Created the next Trigger to move the data from a main table to an historical table in case of an update or insert. CREATE OR REPLACE FUNCTION process_employee_hist() RETURNS TRIGGER AS $...
user avatar
1 vote
1 answer
101 views

TABLE 1 CODE VALUE AA 21 AA 32 AB 24 AC 22 AA 42 AC 20 AD 27 AD 28 AE 29 AF 31 AG 45 AE 51 AH 33 TABLE 2 CODE KEY AA 1 AB 2 AC 3 AD 4 AE 5 AF 6 AG 7 AH 8 Here i want to transform the table in such a ...
Wmm's user avatar
  • 139

1
2 3 4 5
…
37