Network profile

Jack Douglas

Reputation

35,127

35.1k
29.3k
23.4k

2018
2019
2020
2021

Next tag badge

671/1000 score

144/200 answers

Badges

13

89

169

Newest

Announcer

Next badge

307/500

Impact

307 posts edited

95 helpful flags

5,090 votes cast

Answers (368)

Votes Activity Newest

370	How to insert values into a table from a select query in PostgreSQL?
142	List the database privileges using psql
98	How do I get the current unix timestamp from PostgreSQL?
74	How can I time SQL-queries using psql?
48	How can I use a default value in a Select query in PostgreSQL?

View more →

Reputation (35,127)

+10	How to select the first row of each group?
+10	How to insert values into a table from a select query in PostgreSQL?
+10	How can I time SQL-queries using psql?
+10	How should I best name my timestamp fields?

View more →

Questions (61)

Votes Activity Newest

141	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?
31	How to implement a 'default' flag that can only be set on a single row
20	How can I generate a random bytea

View more →

Tags (232)

1k postgresql × 137	157 oracle-11g-r2 × 33
674 oracle × 163	155 permissions × 4
392 insert × 6	152 database-design × 21
216 psql × 2	147 index × 25
183 performance × 28	146 sql-server × 32

View more →

Bookmarks (45)

Votes Activity Newest Views Added

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

View more →

Accounts (10)

	Database Administrators	35,127 rep	13 gold badges89 silver badges169 bronze badges
	Biblical Hermeneutics	11,283 rep	8 gold badges54 silver badges107 bronze badges
	Meta Stack Exchange	7,601 rep	2 gold badges20 silver badges36 bronze badges
	Christianity	1,225 rep	12 silver badges15 bronze badges
	Stack Overflow	101 rep	1 silver badge3 bronze badges

Badges (68)

Recent Class Name

Announcer × 13	Yearling × 9
Popular Question × 31	Notable Question × 19
Constituent × 5	performance
Caucus × 5	Deputy
Nice Answer × 59	Guru × 3

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