Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Adam Matan's user avatar
Adam Matan's user avatar
Adam Matan's user avatar
Adam Matan
  • Member for 13 years, 3 months
  • Last seen more than a month ago
198 votes
14 answers
272k views

SQL: SELECT All columns except some

127 votes
10 answers
365k views

mysql: Show GRANTs for all users

94 votes
4 answers
179k views

MySQL: Create index If not exists

82 votes
6 answers
80k views

What is the best way to store an email address in PostgreSQL?

49 votes
6 answers
169k views

MySQL Set UTC time as default timestamp

43 votes
6 answers
58k views

PostgreSQL: Force data into memory

33 votes
1 answer
37k views

Why does PostgreSQL allow querying for array[0] even though it uses 1-based arrays?

31 votes
5 answers
14k views

MySQL console: Ctrl+C driving me nuts

25 votes
5 answers
74k views

PostgreSQL: Creation date of a table

24 votes
2 answers
18k views

Trigger: move deleted rows to archive table

21 votes
1 answer
14k views

PostgeSQL 9.3: Is it safe to stop VACUUM FULL?

19 votes
2 answers
56k views

Postgresql: set default psql client encoding

18 votes
2 answers
19k views

Is REINDEX dangerous?

17 votes
1 answer
12k views

PostgreSQL: COUNT(*) uses a sequential scan, not index

16 votes
1 answer
8k views

PostgreSQL: Disk space not released after TRUNCATE

16 votes
1 answer
4k views

PostgreSQL exit status when running a file

16 votes
2 answers
20k views

Official PostgreSQL Capitalization conventions [closed]

16 votes
2 answers
12k views

PostgreSQL: schema diff/patch tool [closed]

15 votes
2 answers
15k views

PostgreSQL: Last access time to table

12 votes
2 answers
6k views

Postgresql 8.3: Limit resource consumption per query

12 votes
1 answer
9k views

MySQL table creation insanely slow

11 votes
1 answer
18k views

Postgresql 9.3: Add Unique constraint using an existing unique index

10 votes
2 answers
6k views

Show DOMAIN details

9 votes
1 answer
12k views

PostgreSQL 9.3: Dump a database excluding the data of some tables

9 votes
1 answer
30k views

MySQL: Illegal mix of collations

8 votes
2 answers
74k views

MySQL user permission on stored procedure

8 votes
2 answers
6k views

PostgreSQL: SET-ing from psql arguments

8 votes
1 answer
66k views

MySQL format numbers with comma [closed]

8 votes
2 answers
8k views

Why isn't to_char IMMUTABLE, and how can I work around it?

7 votes
2 answers
25k views

Can't run digest() on PosrgreSQL 9.3 on RDS