How should I organize my workflow so that I can quickly design & modify my database structure? I have tried pgAdmin, but it seems to me that writing sql scripts would be faster.
I want to be able to write my CREATE TABLE queries, and my environment would parse them, modify database tables' structure for me, copy the data where it's possible (for columns that remained intact), and returned modified database to me, Is similar environment exist?
If not, then what kind of workflow you use / advice?