user avatar
user avatar
user avatar
Victoria Stuart
  • Member for 5 years, 3 months
  • Last seen this week
3 votes
2 answers
2k views

What's the (Big O) computational complexity of a PostgreSQL recursive common table expression?

44 votes
3 answers
27k views

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

326 votes
4 answers
701k views

How to insert values into a table from a select query in PostgreSQL?

475 votes
2 answers
249k views

What's the difference between a temp table and table variable in SQL Server?

170 votes
5 answers
220k views

How to get the name of the current database from within PostgreSQL?

47 votes
4 answers
58k views

How to turn off header only in psql (postgresql)

7 votes
4 answers
54k views

psql denies access to file when using COPY FROM

30 votes
2 answers
47k views

How to duplicate the database in postgresql?

1 vote
1 answer
2k views

Constraint on multiple columns?

7 votes
3 answers
24k views

Improving RAM and CPU utilization by PostgreSQL 9.6

186 votes
7 answers
200k views

What's the difference between a CTE and a Temp Table?

1 vote
1 answer
1k views

Type of an id field that references another id field

38 votes
1 answer
34k views

Need for indexes on foreign keys