Skip to main content
The 2024 Developer Survey results are live! See the results
Database Administrators
Erwin Brandstetter's user avatar
Erwin Brandstetter's user avatar
Erwin Brandstetter's user avatar
Erwin Brandstetter
  • Member for 12 years, 10 months
  • Last seen this week
  • Vienna, Austria
Profile Activity
Stats
178,886
reputation
22.7m
reached
2,183
answers
12
questions
Communities
View all
About

I work as PostgreSQL consulter, in case you need one.
Find my email address in the official list of Postgres contributors.

Badges
View all badges
27
gold badges
447
silver badges
610
bronze badges
Top tags
View all tags
15,206
Score
2,156
Posts
98
Posts %
2,658
Score
217
Posts
10
Posts %
2,653
Score
309
Posts
14
Posts %
1,385
Score
263
Posts
12
Posts %
1,358
Score
174
Posts
8
Posts %
1,305
Score
206
Posts
9
Posts %
Top posts
View all questions and answers
253
Optimizing queries on a range of timestamps (two columns)
Apr 9, 2013
237
Pattern matching with LIKE, SIMILAR TO or regular expressions
Jan 15, 2012
210
Postgres UPDATE ... LIMIT 1
Jul 1, 2014
182
How to turn JSON array into Postgres array?
Dec 2, 2013
175
PostgreSQL multi-column unique constraint and NULL values
Dec 27, 2011
152
Measure the size of a PostgreSQL table row
Sep 8, 2012
137
Difference between now() and current_timestamp
Apr 21, 2014
133
Create index if it does not exist
Feb 27, 2013
133
Is a composite index also good for queries on the first field?
Oct 23, 2012
131
How to manage DEFAULT PRIVILEGES for USERs on a DATABASE vs SCHEMA?
Oct 11, 2015
Top Meta posts
5
17
25
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
Markdown issue with # in PostgreSQL code
11
Are we on the same page with [pagination] and [paging]?
11
Is the [sql] tag useful for DBA.SE?
Top network posts
View all network posts
1800
Select first row in each GROUP BY group?
1304
Insert text with single quotes in PostgreSQL
1078
PostgreSQL error: Fatal: role "username" does not exist
667
Create unique constraint with null columns
602
Select rows which are not present in other table