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, 3 months
  • Last seen more than a month ago
1 vote
1 answer
44 views

How I can order my results by relevance when using like?

0 votes
0 answers
25 views

Why my fulltext search fails to return values?

0 votes
1 answer
695 views

How I can merge 2 databases into a single one?

0 votes
0 answers
66 views

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

0 votes
1 answer
47 views

How I can place further constraints upon foreign key?

0 votes
2 answers
125 views

How I can check whether 2 databases haves same data and schema fast?

0 votes
1 answer
28 views

Why constraint fails on preventing the insert statement execution?

0 votes
1 answer
52 views

How to drop a unique index that is used upon a foreighn key?

1 vote
0 answers
17 views

How I can generate statistics for my less used columns of a specific table in my database?

0 votes
1 answer
384 views

Detect duplicate records before aplying a unique Index in postgresql

1 vote
1 answer
1k views

Would refreshing a materialized view in a transaction allow me to have test-only specific data on it?

1 vote
1 answer
759 views

How I can find which sequence is associated with a Primary Key of Serial type? [duplicate]

3 votes
2 answers
1k views

What the difference between User, Login and role in postgresql?

0 votes
1 answer
144 views

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

1 vote
1 answer
119 views

How I can retrieve the latest records without using lateral join?

0 votes
1 answer
32 views

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

0 votes
2 answers
108 views

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

0 votes
1 answer
258 views

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

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
31 views

Can subqueries decrease the data fetching times?

0 votes
1 answer
5k views

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

2 votes
1 answer
3k views

How I can remove autoincrement from a Primary key in postgresql?

0 votes
1 answer
3k views

Count how many times a combination of columns occur

0 votes
1 answer
149 views

How I can update one database schema to another database?

0 votes
0 answers
15 views

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

0 votes
1 answer
649 views

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

1 vote
1 answer
389 views

How I can find out the foreign wrapper that a foreign table belongs to?

0 votes
1 answer
491 views

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

1 vote
2 answers
12k views

How I can filter a array_agg value in postgresql?