Skip to main content
Daniel Vérité's user avatar
Daniel Vérité's user avatar
Daniel Vérité's user avatar
Daniel Vérité
  • Member for 12 years, 4 months
  • Last seen this week
1 vote
Accepted

How to have Postgres return id when ON CONFLICT DO NOTHING

1 vote
Accepted

Full Text Search on Postgres jsonb column

1 vote

What is the difference between CURRENT_TIMESTAMP::DATE and CURRENT_DATE in PostgreSQL?

1 vote
Accepted

PostgreSQL plan cache and variable number of arguments

1 vote
Accepted

"Unsupported version" error restoring a schema backed up with the same version it was dumped

2 votes

PostgreSQL's unaccent function is unable to remove accents (diacritic signs) from Japanese characters like 'ド'

2 votes
Accepted

Is there a way to install PostgreSQL using apt-get without it running initdb automatically?

9 votes
Accepted

What's the difference between FETCH FIRST and FETCH NEXT in PostgreSQL?

8 votes

copy command in postgresql to append data

1 vote

How can I cleanly recreate the main postgresql cluster?

2 votes
Accepted

Issues using a psql -v variable with jsonb_set

1 vote

Using PostgreSQL

1 vote

PostgreSQL notifications aren't working

2 votes
Accepted

pg_dump.exe compared to MS SQL backup

4 votes
Accepted

psql \set an environment variable from the existing shell environment

1 vote
Accepted

Why is dblink nested function rolling back?

3 votes
Accepted

Why does my Postgres function always return the same value, regardless of input?

2 votes
Accepted

PostgreSQL doesn't sort according to `LC_COLLATE=C` even though DB is configured to

2 votes
Accepted

Index for searching in column where the column starts with the provided value

4 votes
Accepted

postgresql matching or converting utf-8 variant strings

2 votes
Accepted

Can two tables ever get the same OID on pg_class?

2 votes
Accepted

Postgres encoding issue - find values that have no equivalent in (client) encoding

2 votes
Accepted

pg_dump output formats

10 votes
Accepted

What does PostgreSQL Status active (exited) mean?

0 votes

Need to free up space by removing pg_wal files in Postgres

1 vote

How to query 30k of entries from an external data source by script

2 votes

Limit my ticker count to maximum 12 Months

2 votes
Accepted

OID release ranges for built-in (aka standard) database objects during PostgreSQL installation

5 votes

SQL Comments disappear with psql and `\e`

1 vote
Accepted

psql cannot connect to local database after changing data directory

1
2 3 4 5
16