Network profile

Jack Douglas

Reputation

35,966

36k
30.7k
25.5k

2018
2019
2020
2021

Next tag badge

671/1000 score

144/200 answers

Badges

14

91

171

Newest

Announcer

Next badge

307/500

Impact

307 posts edited

95 helpful flags

5,090 votes cast

Answers (368)

Votes Activity Newest

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

View more →

Reputation (35,966)

+10	How to insert (file) data into a PostgreSQL bytea column?
+10	How to insert values into a table from a select query in PostgreSQL?
+10	How do I get the current unix timestamp from PostgreSQL?
+10	Is there a way to access temporary tables of other sessions in postgres?

View more →

Questions (61)

Votes Activity Newest

145	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	163 permissions × 4
684 oracle × 163	159 oracle-11g-r2 × 33
420 insert × 6	153 database-design × 21
226 psql × 2	150 ubuntu
185 performance × 28	148 index × 25

View more →

Bookmarks (45)

Votes Activity Newest Views Added

104	Where are some useful SQL puzzles to teach SQL in a workplace?
85	Working of indexes in PostgreSQL
38	Error Code 1117 Too many columns; MySQL column-limit on table
37	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	35,966 rep	14 gold badges91 silver badges171 bronze badges
	Biblical Hermeneutics	11,571 rep	9 gold badges54 silver badges111 bronze badges
	Meta Stack Exchange	7,621 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

Announcer × 14	Constituent × 5
Yearling × 10	Caucus × 5
Notable Question × 20	Nice Answer × 59
Great Answer × 3	performance
Popular Question × 32	Deputy

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