user avatar
user avatar
user avatar
Victoria Stuart
  • Member for 5 years, 3 months
  • Last seen this week
1 vote
1 answer
2k views

Constraint on multiple columns?

326 votes
4 answers
701k views

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

  • 30.2k
7 votes
4 answers
54k views

psql denies access to file when using COPY FROM

  • 173
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)

  • 571
3 votes
2 answers
2k views

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

186 votes
7 answers
200k views

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

  • 8,289
475 votes
2 answers
249k views

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

  • 78.4k
30 votes
2 answers
47k views

How to duplicate the database in postgresql?

38 votes
1 answer
34k views

Need for indexes on foreign keys

  • 707
44 votes
3 answers
27k views

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

7 votes
3 answers
24k views

Improving RAM and CPU utilization by PostgreSQL 9.6

  • 313
1 vote
1 answer
1k views

Type of an id field that references another id field