[GENERAL] views get 'lost'

[Christoph Pingel]

I'm still quite new to postgres, struggeling with 'views'... I'm on 
OS X, using aquadatastudio to interface the db.

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 [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly