Skip to main content
Dimitrios Desyllas's user avatar
Dimitrios Desyllas's user avatar
Dimitrios Desyllas's user avatar
Dimitrios Desyllas
  • Member for 7 years, 4 months
  • Last seen more than a month ago
0 votes
0 answers
67 views

How I can sync the data upon updating and deleting from adjacency list table into closure one?

0 votes
0 answers
26 views

Why my fulltext search fails to return values?

0 votes
1 answer
152 views

Would logical replication will allow me to merge 2 database into differenct schemas?

0 votes
1 answer
710 views

How I can merge 2 databases into a single one?

0 votes
1 answer
5k views

How to match a column against an array of seach strings?

0 votes
1 answer
31 views

Can subqueries decrease the data fetching times?

0 votes
2 answers
59 views

What I make wrong and Cannot inset a value at sqlite3 using custom trigger?

0 votes
1 answer
43 views

How I can make a single trigger for both create and update at sqlite3?

0 votes
1 answer
261 views

Is good idea to split the JSONB field into a separate table in my case?

0 votes
2 answers
116 views

How I can check whether a column contains a substring of a given searchterm?

0 votes
1 answer
32 views

How I can find a best match on string records that use * as a wildcard?

0 votes
1 answer
391 views

Detect duplicate records before aplying a unique Index in postgresql

0 votes
1 answer
158 views

Jailer exclude tables to be exported

0 votes
1 answer
4k views

In case of inserted a fixed value into autoincrement how to automatically skip into the next sequence value without causing insert to have an error?

0 votes
1 answer
436 views

Manually VACUUM bloated tables once `hot_standby_feedback` is on on postgresql?

0 votes
1 answer
1k views

Replication testing is a Materialized view Refresh equivalent of continious update?

0 votes
1 answer
162 views

I have hard time understanding Postgresql OVERLAP function when provided Interval

0 votes
1 answer
497 views

Can a pg_dump or a pg_dump_all can cause timeouts in queries running in parallel?

0 votes
1 answer
655 views

How I can create a foreign table using a foreign data wrapper that references to a remote one with the same name?

0 votes
0 answers
15 views

Why I am unable to copy data from one table to another?

0 votes
1 answer
150 views

How I can update one database schema to another database?

0 votes
1 answer
4k views

Count how many times a combination of columns occur

0 votes
1 answer
135 views

How I can check whether 2 databases despite being in different postgresql servers of versions are the same?

0 votes
1 answer
27 views

In which tables values will be inserted if I insert values into a view that its result is made out of inner join of 3 tables?

0 votes
1 answer
91 views

How I can place connection metadata in order to trace my queries on RDS performance insights fot my postgresql db?

0 votes
0 answers
81 views

How I can find the most resource-intensive queries that has ever run in my database and use a specific table?

0 votes
1 answer
848 views

How I can flatten a count table in postgresql that contains only 2 columns with crosstab?

0 votes
2 answers
2k views

How I can find out which views use other views in their sql code that generates them? [duplicate]

-2 votes
1 answer
202 views

How I can search inside the json that is consisted of an array of a JSON into objects?

1
2