views get 'lost'

Started by Christoph Pingelabout 21 years ago1 messagesgeneral
Jump to latest
#1Christoph Pingel
ch.pingel@web.de

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