Jack Douglas

topanswers.xyz
Maidenhead, United Kingdom
Member for 10 years, 6 months

Reputation

36,566

36.6k
31.3k
26.1k

2018
2019
2020
2021

Next tag badge

671/1000 score

144/200 answers

Badges

14

93

172

Newest

Notable Question

Next badge

307/500

Impact

307 posts edited

95 helpful flags

5,090 votes cast

Answers (368)

Votes Activity Newest

422	How to insert values into a table from a select query in PostgreSQL?
158	List the database privileges using psql
111	How do I get the current unix timestamp from PostgreSQL?
76	How can I time SQL-queries using psql?
56	How can I use a default value in a Select query in PostgreSQL?

View more →

Reputation (36,566)

+30	How to insert values into a table from a select query in PostgreSQL?
+10	Should binary files be stored in the database?
+10	How can I generate a random bytea
+10	How can I generate a random bytea

View more →

Questions (61)

Votes Activity Newest

148	Should binary files be stored in the database?
46	How could DBAs be more 'programmer friendly'?
36	Should every table have a single-field surrogate/artificial primary key?
32	How to implement a 'default' flag that can only be set on a single row
22	How can I generate a random bytea

View more →

Tags (232)

2k postgresql × 137	171 permissions × 4
685 oracle × 163	159 oracle-11g-r2 × 33
444 insert × 6	159 aggregate × 10
234 psql × 2	158 ubuntu
186 performance × 28	155 database-design × 21

View more →

Bookmarks (45)

Votes Activity Newest Views Added

104	Where are some useful SQL puzzles to teach SQL in a workplace?
86	Working of indexes in PostgreSQL
39	Error Code 1117 Too many columns; MySQL column-limit on table
38	Is it possible to use SQLite as a client-server database? [closed]
36	I Need to Shrink My Database - I just freed a lot of space

View more →

Accounts (10)

	Database Administrators	36,566 rep	14 gold badges93 silver badges172 bronze badges
	Biblical Hermeneutics	11,899 rep	10 gold badges57 silver badges114 bronze badges
	Meta Stack Exchange	7,707 rep	2 gold badges21 silver badges36 bronze badges
	Christianity	1,215 rep	12 silver badges15 bronze badges
	Stack Overflow	101 rep	1 silver badge3 bronze badges

Badges (68)

Recent Class Name

Notable Question × 21	Great Answer × 3
Enlightened × 18	Popular Question × 32
Nice Answer × 60	Constituent × 5
Announcer × 14	Caucus × 5
Yearling × 10	performance

View more →

Active bounties (0)

Active Offered Earned

This user has no active bounties

Votes cast (5,090)

all time			by type
4,711	up		1,581	question
379	down		3,509	answer

Database Administrators Stack Exchange works best with JavaScript enabled