user avatar
user avatar
user avatar
Victoria Stuart
  • Member for 5 years, 1 month
  • Last seen more than a month ago
475 votes
2 answers
248k views

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

  • 78.2k
324 votes
4 answers
689k views

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

  • 30k
186 votes
7 answers
199k views

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

  • 8,269
168 votes
5 answers
215k views

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

47 votes
4 answers
56k views

How to turn off header only in psql (postgresql)

  • 571
43 votes
3 answers
26k views

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

38 votes
1 answer
34k views

Need for indexes on foreign keys

  • 707
30 votes
2 answers
46k views

How to duplicate the database in postgresql?

7 votes
3 answers
23k views

Improving RAM and CPU utilization by PostgreSQL 9.6

  • 313
7 votes
4 answers
54k views

psql denies access to file when using COPY FROM

  • 173
3 votes
2 answers
2k views

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

1 vote
1 answer
1k views

Type of an id field that references another id field

1 vote
1 answer
2k views

Constraint on multiple columns?