I've got a view which accidentally (don't know how) lost it's name.
Now I can not drop it any longer because pgadmin III throws an error Error: syntax-error at the end of input Line 1:DROP VIEW public
Trying to rename it causes the error Error: syntax-error at "to" Line 1:ALTER TABLE RENAME TO NewName
The view definition is
CREATE OR REPLACE VIEW AS SELECT ... FROM table a; ALTER TABLE OWNER TO postgres; GRANT ALL ON TABLE TO postgres;