Network profile

Jack Douglas

Reputation

34,702

34.7k
28.7k
22.7k

2017
2018
2019
2020

Next tag badge

671/1000 score

144/200 answers

Badges

13

89

167

Newest

Constituent

Next badge

308/500

Impact

308 posts edited

95 helpful flags

5,090 votes cast

Answers (368)

Votes Activity Newest

353	How to insert values into a table from a select query in PostgreSQL?
138	List the database privileges using psql
96	How do I get the current unix timestamp from PostgreSQL?
72	How can I time SQL-queries using psql?
47	How can I use a default value in a Select query in PostgreSQL?

View more →

Reputation (34,702)

+10	Grouping on any one of multiple columns in Postgres
+10	What can go wrong using the same sequence across multiple tables in postgres?
+10	How to insert values into a table from a select query in PostgreSQL?
+10	Finding empty columns of a table in PostgreSQL

View more →

Questions (61)

Votes Activity Newest

136	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	155 oracle-11g-r2 × 33
671 oracle × 163	152 database-design × 21
375 insert × 6	151 permissions × 4
210 psql × 2	147 index × 25
182 performance × 28	145 sql-server × 32

View more →

Bookmarks (45)

Votes Activity Newest Views Added

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

View more →

Accounts (10)

	Database Administrators	34,702 rep	13 gold badges89 silver badges167 bronze badges
	Biblical Hermeneutics	11,123 rep	8 gold badges52 silver badges106 bronze badges
	Meta Stack Exchange	7,571 rep	2 gold badges20 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

Constituent × 5	Yearling × 9
Caucus × 5	Notable Question × 19
Announcer × 12	performance
Popular Question × 30	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			month
4,711	up		1,581	question		1
379	down		3,509	answer		1

Database Administrators Stack Exchange works best with JavaScript enabled