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
6 votes
1 answer
14k views

Split a comma-separated record into its own rows

1 vote
2 answers
12k views

How I can filter a array_agg value in postgresql?

1 vote
2 answers
9k views

Why does my SELECT query not return null values? [duplicate]

5 votes
1 answer
8k views

Postgresql cannot peer authenticate using usermap (provided user name (^dbuser^) and authenticated user name (^sysuser^) do not match)

4 votes
1 answer
5k views

Could once `max_standby_archive_delay` and `max_standby_streaming_delay` with value -1 can cause replication stop on heavy loads?

0 votes
1 answer
5k views

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

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

Count how many times a combination of columns occur

2 votes
1 answer
3k views

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

0 votes
2 answers
2k views

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

1 vote
1 answer
2k views

Postgresql cannot restore partial pg_dump "relation "public.my_table_seq" does not exist"

1 vote
0 answers
2k views

What does the error means: `SQLSTATE[HY000]: General error: 7 SSL SYSCALL error: EOF detected (SQL: )`

2 votes
0 answers
2k views

Does the `hot_standby_feedback=on` may cause `SSL SYSCALL error: EOF detected` error?

1 vote
1 answer
1k views

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

0 votes
1 answer
1k views

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

3 votes
2 answers
1k views

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

1 vote
2 answers
928 views

Replicate a database with a subset of data offered by custom queries [closed]

0 votes
1 answer
845 views

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

1 vote
2 answers
782 views

Creating a foreign server in Postgres only if not exists

1 vote
1 answer
779 views

List Postgresql foreign data wrappers without the use of the `psql` command

1 vote
1 answer
759 views

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

5 votes
3 answers
735 views

Why is NOLOCK implemented like that?

0 votes
1 answer
695 views

How I can merge 2 databases into a single one?

1 vote
1 answer
653 views

How I can monitor Amazon RDS Postgresql table size once the `hot_standby_feedback` is on

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

How to enforce a column value on duplicate values on postgresql using constraint?

0 votes
1 answer
491 views

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

0 votes
1 answer
435 views

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

1 vote
1 answer
388 views

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

0 votes
1 answer
384 views

Detect duplicate records before aplying a unique Index in postgresql