Try selecting from pg_views to see if it exists, then if it does, drop it.
Chris
[EMAIL PROTECTED] wrote:
Hai,
I need a clarification for the below:
I need to check for the existence of a user defined view named 'audit_vw' and if exists, then i need to delete the same. Please help me to solve the issue.
Thanks & Regards Palanivel P.K
Important Email Information :- The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you are not the intended addressee please contact the sender and dispose of this e-mail immediately.
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
