Thread: Drop view

I 'm the fresh user in pgsql,

And now I'm using version 6.5.3 under linux red hat 6.2
I ve made a mistake to create a view " all staff" and can't drop it
everytime I descript or drop the view , it appear Error as below  :

template1> \d all staff;
ERROR: nodeRead : Bad type 0
template1>drop view all staff;
ERROR :parser: parser error at or near "all"


Kindly advise how to drop the view without error,

Thanks & regards

Keith Siu <keith@kanetop.com> writes:
> I ve made a mistake to create a view " all staff" and can't drop it
> everytime I descript or drop the view , it appear Error as below  :

> template1> \d all staff;
> ERROR: nodeRead : Bad type 0
> template1>drop view all staff;
> ERROR :parser: parser error at or near "all"

Try quoting the name properly:

    drop view " all staff";

BTW, 6.5.3 is ancient.  Consider updating.

            regards, tom lane