Skip to main content
Joishi Bodio's user avatar
Joishi Bodio's user avatar
Joishi Bodio's user avatar
Joishi Bodio
  • Member for 10 years, 10 months
  • Last seen more than 3 years ago
30 votes

Quoting columns with spaces in PostgreSQL?

26 votes
Accepted

What is the difference between an after update and a before update in PostgreSQL

20 votes
Accepted

How to add a check constraint in Postgres without locking the table?

13 votes

Get statistics of slow running queries

9 votes

psql, getting a list of databases to be parsed by a script

9 votes

Delete all data in Postgres database

9 votes

How can this unique index allow duplicate rows?

9 votes

Why do composite foreign keys need a separate unique constraint?

8 votes

Postgres cannot simulate table with a view: column must appear in the GROUP BY clause or be used in an aggregate function

8 votes
Accepted

How to grant access to IP range in Postgres?

6 votes
Accepted

How to avoid invoking functions twice when using GROUP BY and HAVING?

6 votes
Accepted

pg_stat_statements not found even with "shared_preload_libraries = 'pg_stat_statements'

5 votes
Accepted

When can I clean up archived WAL files?

5 votes

Why would a query work slower when a where clause is added?

4 votes

Copy table with separate sequences for serial columns

4 votes

unique constraint on a column with duplicate values

4 votes
Accepted

LIKE Operator not returning desired result after using LOWER

3 votes

How to optimize a join based on a "like" in postgres

3 votes
Accepted

How to get first value from list of value

3 votes

standard solution for storing units of measure

3 votes
Accepted

PostgreSQL function thinks table reference exists when it does not

3 votes
Accepted

Postgresql csv to db translate foreign keys

3 votes

Use result of aggregate in same select?

3 votes
Accepted

Compare only day / month / year portion of a timestamp field

3 votes
Accepted

Postgres restore unclear behaviour

3 votes
Accepted

improve long running query

2 votes
Accepted

How do I include zeros in a count(column)?

2 votes

Why does connecting to '127.0.0.1' work whilst 'localhost' fails?

2 votes
Accepted

How to update records of one table with the values of another one (PostgreSQL)

2 votes
Accepted

WAL files are not copied