Skip to main content
The 2026 Annual Developer Survey is live— take the Survey today!
Magnus Hagander's user avatar
Magnus Hagander's user avatar
Magnus Hagander's user avatar
Magnus Hagander
  • Member for 17 years, 2 months
  • Last seen more than 12 years ago
Profile Activity

Profile

Stats

25,536
reputation
4.0m
reached
203
answers
0
questions
Communities

Badges

View all badges
6
gold badges
61
silver badges
44
bronze badges

Top tags

View all tags
2,368
Score
203
Posts
100
Posts %
657
Score
33
Posts
16
Posts %
490
Score
25
Posts
12
Posts %
200
Score
6
Posts
3
Posts %
82
Score
19
Posts
9
Posts %
78
Score
10
Posts
5
Posts %

Top posts

View all questions, answers, and articles
answer
494
How do I convert an interval into a number of hours with postgres?
Jun 4, 2009
answer
368
Right query to get the current number of connections in a PostgreSQL DB
Mar 11, 2011
answer
120
Postgres error on insert - ERROR: invalid byte sequence for encoding "UTF8": 0x00
Aug 28, 2009
answer
110
Constraint name update in PostgreSQL
Jun 10, 2009
answer
89
How to list table foreign keys
Jul 20, 2009
answer
87
SQL explain plan: what is Materialize?
Jun 13, 2010
answer
81
Postgresql constraint
Jun 9, 2010
answer
79
PostgreSQL - disabling constraints
Apr 21, 2010
answer
64
Does PostgreSQL support transparent compressing of tables (fragments)?
Sep 3, 2009
answer
40
how to emulate "insert ignore" and "on duplicate key update" (sql merge) with postgresql?
Jun 18, 2009

Top network posts

View all network posts
62
Is PostgreSQL suited to one OS? Is it better on Linux than Windows?
30
What's the required to make a normal user can create schema on PostgreSQL?
13
PostgreSQL hangs during shut down in linux?
13
Possible to have nested inserts in Postgres 8.4?
12
postgresql replication - pg_stat_replication is showing empty columns