Mike Sherrill 'Cat Recall''s user avatar
Mike Sherrill 'Cat Recall''s user avatar
Mike Sherrill 'Cat Recall''s user avatar
Mike Sherrill 'Cat Recall'
  • Member for 13 years, 1 month
  • Last seen more than a month ago
  • United States
157 votes

List all columns for a specified table

79 votes
Accepted

How to get a working and complete PostgreSQL DB backup and test

49 votes

Good explanation of cascade (ON DELETE/UPDATE) behavior

45 votes
Accepted

How do I know what indexes to create for a table?

43 votes

What are the arguments against or for putting application logic in the database layer?

23 votes
Accepted

Proper Use of Lookup Tables

21 votes
Accepted

Arbitrarily ordering records in a table

18 votes
Accepted

Database design: Dividing multiple identical tables, good or bad?

17 votes
Accepted

Is it possible to avoid filesort?

17 votes

Enforcing database integrity

16 votes
Accepted

Foreign keys - link using surrogate or natural key?

15 votes
Accepted

What is Atomic Relation in First Normal Form

14 votes

Normalization: Is it considered compliant to split static, numeric values like a year into their own table?

13 votes
Accepted

PostgreSQL: Disk space not released after TRUNCATE

12 votes
Accepted

PostgreSQL and default Schemas

12 votes
Accepted

Constraint on Composite Type

11 votes
Accepted

Foreign Keys with Composite Key

10 votes

PRIMARY KEY CONSTRAINT fundamentals

10 votes
Accepted

Is the optimisation fence behaviour of a CTE (WITH query) specified in the SQL:2008 standard? If so, where?

10 votes

How can I losslessly decompose this table?

9 votes
Accepted

Estimating impact of indexes SQLite database size

9 votes

Sort order specified in primary key, yet sorting is executed on SELECT

9 votes
Accepted

"AT TIME ZONE" with zone name PostgreSQL bug?

9 votes

Where are PostgreSQL databases stored on my computer?

8 votes

What are the differences between "Stored Procedures" and "Stored Functions"?

8 votes

Is there a reason to use extremely abbreviated table names?

7 votes
Accepted

Select column from ALL tables

7 votes
Accepted

Pros and Cons of having additional columns in join table of many to many relationship

7 votes
Accepted

6th normal form, recomposition query, efficient implementation

7 votes

Is it ok to let users add new columns and tables to your database?

1
2 3 4 5 6