Database Administrators
Sponsored by
Sponsored logo
user avatar
user avatar
user avatar
Erwin Brandstetter
  • Member for 10 years, 7 months
  • Last seen this week
  • Vienna, Austria
Profile Activity
Stats
150,420
reputation
16.1m
reached
1,939
answers
11
questions
Communities
View all
About

Database expert.
Warmongers make peace before asking questions.

Badges
View all badges
19
gold badges
361
silver badges
506
bronze badges
Top tags
View all tags
12,669
Score
1,912
Posts
98
Posts %
2,334
Score
301
Posts
15
Posts %
2,271
Score
192
Posts
10
Posts %
1,124
Score
157
Posts
8
Posts %
1,120
Score
222
Posts
11
Posts %
1,095
Score
190
Posts
10
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
237
Optimizing queries on a range of timestamps (two columns)
Apr 9, 2013
answer
209
Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL
Jan 15, 2012
answer
179
Postgres UPDATE ... LIMIT 1
Jul 1, 2014
answer
148
How to turn JSON array into Postgres array?
Dec 2, 2013
answer
143
PostgreSQL multi-column unique constraint and NULL values
Dec 27, 2011
answer
134
Measure the size of a PostgreSQL table row
Sep 8, 2012
answer
118
Create index if it does not exist
Feb 27, 2013
answer
117
How to manage DEFAULT PRIVILEGES for USERs on a DATABASE vs SCHEMA?
Oct 11, 2015
answer
115
Is a composite index also good for queries on the first field?
Oct 23, 2012
answer
108
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
9
Markdown issue with # in PostgreSQL code
Top network posts
View all network posts
1501
Select first row in each GROUP BY group?
1054
Insert text with single quotes in PostgreSQL
970
PostgreSQL error: Fatal: role "username" does not exist
510
Select rows which are not present in other table
474
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.