Skip to main content
The 2026 Annual Developer Survey is live— take the Survey today!
Patrick's user avatar
Patrick's user avatar
Patrick's user avatar
Patrick
  • Member for 12 years, 5 months
  • Last seen more than a month ago
  • Spain
Profile Activity

Profile

Stats

33,153
reputation
4.5m
reached
842
answers
16
questions
Collectives
R Language
2024 • Member
Communities

About

Using PostgreSQL for any and all data management tasks

Badges

View all badges
7
gold badges
74
silver badges
102
bronze badges

Top tags

View all tags
2,466
Score
765
Posts
89
Posts %
702
Score
260
Posts
30
Posts %
208
Score
31
Posts
4
Posts %
189
Score
44
Posts
5
Posts %
135
Score
53
Posts
6
Posts %
120
Score
51
Posts
6
Posts %

Top posts

View all questions, answers, and articles
answer
189
UUID or SEQUENCE for primary key?
Oct 22, 2015
answer
180
PostgreSQL array of elements that each are a foreign key
Dec 9, 2016
answer
101
How to create guid in PostgreSQL
Jul 6, 2015
answer
75
PostgreSQL: Give all permissions to a user on a PostgreSQL database
Mar 18, 2014
answer
70
Handling Unicode sequences in postgresql
Jul 28, 2015
answer
58
"missing FROM-clause entry for table" error for a rails table query
May 9, 2014
answer
56
Extract key, value from json objects in Postgres
Aug 18, 2016
answer
44
sql SUM: change null with 0
Oct 18, 2016
answer
36
Select value of array from jsonb column in PostgreSQL
Oct 19, 2016
answer
32
Postgres CSV COPY from/import is not respecting CSV headers
Oct 22, 2015

Top Meta posts

2
3
158
A car with square wheels
35
Enhance moderation ability by encouraging excellent content
9
Answer acceptance to count toward tag score
5
Change in attribution of question editing by "new" user?

Top network posts

View all network posts
8
How to migrate a database from a local to a remote server?