Database Administrators
Sponsored by
Sponsored logo
user avatar
user avatar
user avatar
Erwin Brandstetter
  • Member for 10 years, 10 months
  • Last seen this week
  • Vienna, Austria
Profile Activity
Stats
154,304
reputation
16.8m
reached
1,976
answers
11
questions
top 0.04% this year
Communities
View all
About

Database expert. PostgreSQL contributor.

Badges
View all badges
19
gold badges
378
silver badges
522
bronze badges
Top tags
View all tags
13,003
Score
1,949
Posts
98
Posts %
2,374
Score
302
Posts
15
Posts %
2,326
Score
197
Posts
10
Posts %
1,153
Score
160
Posts
8
Posts %
1,147
Score
226
Posts
11
Posts %
1,119
Score
190
Posts
10
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
238
Optimizing queries on a range of timestamps (two columns)
Apr 9, 2013
answer
213
Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL
Jan 15, 2012
answer
186
Postgres UPDATE ... LIMIT 1
Jul 1, 2014
answer
154
How to turn JSON array into Postgres array?
Dec 2, 2013
answer
150
PostgreSQL multi-column unique constraint and NULL values
Dec 27, 2011
answer
135
Measure the size of a PostgreSQL table row
Sep 8, 2012
answer
120
Create index if it does not exist
Feb 27, 2013
answer
118
How to manage DEFAULT PRIVILEGES for USERs on a DATABASE vs SCHEMA?
Oct 11, 2015
answer
116
Is a composite index also good for queries on the first field?
Oct 23, 2012
answer
112
Difference between now() and current_timestamp
Apr 21, 2014
Top Meta posts
5
16
24
Can We / Should We Strongly Encourage Users to Specify RDBMS on the "Ask" page?
13
It has been a great privilege to serve this amazing community as moderator. Thank you
11
Is the [sql] tag useful for DBA.SE?
10
I don't think the votes on my answer are merited
10
Markdown issue with # in PostgreSQL code
Top network posts
View all network posts
1543
Select first row in each GROUP BY group?
1084
Insert text with single quotes in PostgreSQL
994
PostgreSQL error: Fatal: role "username" does not exist
524
Select rows which are not present in other table
495
Create unique constraint with null columns

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.