All Questions
2 questions
0
votes
0
answers
771
views
Possibility of using self-referential foreign key to create hierarchical comments
I am an accidental DBA and have a question regarding the table structure of a website I maintain (postgresql 9.6 backend).
Imagine a typical content website (let's call it 'Links'), where users post ...
- 2,039
4
votes
1
answer
4k
views
postgresql replace table without losing dependancies
i want to replace an existing table with a new one, without losing foreign keys or inheritance relations. But I feel lazy to alter it to make it look like the new one. Is there a way to replace the ...
- 257