Search Postgresql Archives

views get 'lost'

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 majordomo@xxxxxxxxxxxxxx so that your
     message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux