Victoria Stuart
  • Member for 4 years, 8 months
  • Last seen more than a month ago
2 answers
470 votes
246k views
308 bookmarks
What's the difference between a temp table and table variable in SQL Server?
3 answers
302 votes
641k views
41 bookmarks
How to insert values into a table from a select query in PostgreSQL?
7 answers
184 votes
196k views
100 bookmarks
What's the difference between a CTE and a Temp Table?
5 answers
153 votes
199k views
23 bookmarks
How to get the name of the current database from within PostgreSQL?
3 answers
41 votes
25k views
14 bookmarks
How do I know what indexes to create for a table?
4 answers
41 votes
52k views
7 bookmarks
How to turn off header only in psql (postgresql)
1 answers
38 votes
33k views
8 bookmarks
Need for indexes on foreign keys
2 answers
29 votes
45k views
10 bookmarks
How to duplicate the database in postgresql?
3 answers
7 votes
21k views
3 bookmarks
Improving RAM and CPU utilization by PostgreSQL 9.6
4 answers
7 votes
52k views
2 bookmarks
psql denies access to file when using COPY FROM
2 answers
3 votes
2k views
1 bookmarks
What's the (Big O) computational complexity of a PostgreSQL recursive common table expression?
1 answers
1 votes
1k views
1 bookmarks
Type of an id field that references another id field
1 answers
1 votes
1k views
1 bookmarks
Constraint on multiple columns?