Now, after issuing a 'CREATE VIEW' command, I get back a '1 record affected' message, and I can use the view. However, the view doesn't appear in the tree view of aquadatastudio (even after reconnecting), and after restarting postgresql, it's lost. I used to think that 'CREATE VIEW...' is all I have to do, am I wrong?
TIA, Christoph
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly