On Tue, 10 May 2005 [EMAIL PROTECTED] wrote:
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.
If you don't need to do anything else in the transaction, you could just
issue "DROP VIEW audit_v
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
umar" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Saturday, March 22, 2003 8:42 PM
> Subject: Re: [HACKERS] Please clarify with regard to Renaming a Sequence
>
>
> > >From what I can see the sequence name is not
>From what I can see the sequence name is not changed when you rename a
table
test=# alter table fooseq rename to fooseq1;
ALTER TABLE
test=# \d fooseq1
Table "public.fooseq1"
Column | Type | Modifiers
+-+-
