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
1 vote
1 answer
48 views

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

0 votes
0 answers
26 views

Why my fulltext search fails to return values?

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
1 answer
47 views

How I can place further constraints upon foreign key?

0 votes
2 answers
127 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
391 views

Detect duplicate records before aplying a unique Index in postgresql

1 vote
1 answer
779 views

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

0 votes
1 answer
709 views

How I can merge 2 databases into a single one?

3 votes
2 answers
1k views

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

0 votes
1 answer
151 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
116 views

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

0 votes
1 answer
261 views

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

0 votes
1 answer
43 views

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

0 votes
2 answers
59 views

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

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
4k views

Count how many times a combination of columns occur

0 votes
1 answer
150 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
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
1 answer
497 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?

-2 votes
1 answer
202 views

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

6 votes
1 answer
15k views

Split a comma-separated record into its own rows