User Erwin Brandstetter - Stack Overflow

1800 votes

Select first row in each GROUP BY group?

answered Oct 3, 2011 at 2:21

1304 votes

Accepted

Insert text with single quotes in PostgreSQL

answered Sep 7, 2012 at 15:06

1078 votes

Accepted

PostgreSQL error: Fatal: role "username" does not exist

answered Aug 12, 2012 at 4:13

667 votes

Accepted

Create unique constraint with null columns

answered Nov 27, 2011 at 21:34

602 votes

Accepted

Select rows which are not present in other table

answered Oct 14, 2013 at 16:22

567 votes

Accepted

Fast way to discover the row count of a table in PostgreSQL

answered Oct 30, 2011 at 13:47

517 votes

Accepted

Best way to check for "empty or null value"

answered May 20, 2014 at 18:47

495 votes

Accepted

Are PostgreSQL column names case-sensitive?

answered Jan 2, 2014 at 9:53

480 votes

PostgreSQL create table if not exists

answered Sep 15, 2011 at 22:34

475 votes

Accepted

PostgreSQL: Give all permissions to a user on a PostgreSQL database

answered Mar 18, 2014 at 16:56

474 votes

Accepted

Check if value exists in Postgres array

answered Jun 27, 2012 at 17:37

459 votes

Accepted

PostgreSQL Crosstab Query

answered Aug 1, 2012 at 2:48

453 votes

Accepted

How to implement a many-to-many relationship in PostgreSQL?

answered Mar 20, 2012 at 15:52

441 votes

IN vs ANY operator in PostgreSQL

answered Jan 6, 2016 at 7:21

432 votes

How to use RETURNING with ON CONFLICT in PostgreSQL?

answered Feb 14, 2017 at 4:27

429 votes

How do I (or can I) SELECT DISTINCT on multiple columns?

answered Sep 28, 2012 at 0:50

421 votes

Accepted

How to check if a table exists in a given schema

answered Jun 6, 2014 at 19:58

414 votes

Accepted

Concatenate multiple result rows of one column into one, group by another column

answered Apr 6, 2013 at 11:44

400 votes

Accepted

Ignoring time zones for Postgres timestamps

answered Mar 6, 2012 at 0:21

395 votes

Accepted

PostgreSQL LIKE query performance variations

answered Nov 19, 2012 at 11:08

375 votes

Accepted

What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?

answered Feb 17, 2015 at 8:40

368 votes

Accepted

Query a parameter (postgresql.conf setting) like "max_connections"

answered Nov 27, 2011 at 20:42

360 votes

Accepted

Query for array elements inside JSON type

answered Mar 29, 2014 at 22:25

358 votes

Accepted

Run a query with a LIMIT/OFFSET and also get the total number of rows

answered Mar 5, 2015 at 22:06

358 votes

How to concatenate columns in a Postgres SELECT?

answered Nov 13, 2013 at 1:09

352 votes

Accepted

Best way to select random rows PostgreSQL

answered Dec 30, 2011 at 1:02

317 votes

Accepted

Does PostgreSQL support "accent insensitive" collations?

answered Jun 13, 2012 at 1:51

301 votes

Postgres manually alter sequence

answered Jan 5, 2012 at 22:46

291 votes

Select first row in each GROUP BY group?

answered Jan 11, 2016 at 6:05

281 votes

Accepted

Sort NULL values to the end of a table

answered Oct 1, 2011 at 18:13

Collectives™ on Stack Overflow

6,858 Answers

Select first row in each GROUP BY group?

Insert text with single quotes in PostgreSQL

PostgreSQL error: Fatal: role "username" does not exist

Create unique constraint with null columns

Select rows which are not present in other table

Fast way to discover the row count of a table in PostgreSQL

Best way to check for "empty or null value"

Are PostgreSQL column names case-sensitive?

PostgreSQL create table if not exists

PostgreSQL: Give all permissions to a user on a PostgreSQL database

Check if value exists in Postgres array

PostgreSQL Crosstab Query

How to implement a many-to-many relationship in PostgreSQL?

IN vs ANY operator in PostgreSQL

How to use RETURNING with ON CONFLICT in PostgreSQL?

How do I (or can I) SELECT DISTINCT on multiple columns?

How to check if a table exists in a given schema

Concatenate multiple result rows of one column into one, group by another column

Ignoring time zones for Postgres timestamps

PostgreSQL LIKE query performance variations

What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?

Query a parameter (postgresql.conf setting) like "max_connections"

Query for array elements inside JSON type

Run a query with a LIMIT/OFFSET and also get the total number of rows

How to concatenate columns in a Postgres SELECT?

Best way to select random rows PostgreSQL

Does PostgreSQL support "accent insensitive" collations?

Postgres manually alter sequence

Select first row in each GROUP BY group?

Sort NULL values to the end of a table