views get 'lost'
Started by Christoph Pingelabout 21 years ago1 messagesgeneral
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