Re: pg_attribute.attname

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: pw <p(dot)willis(at)telus(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_attribute.attname
Date: 2004-09-09 20:41:33
Message-ID: 20040909204133.GA22919@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 09, 2004 at 01:07:12PM -0700, pw wrote:
> Hello,
>
> How do I clear out dropped column names that appear in
> pg_attribute.attname automatically?

I don't think you can. Just ignore columns where is_dropped is true.

Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message peter Willis 2004-09-09 20:47:15 Re: Where does postgres store records of DROP-ed columns?
Previous Message Vivek Khera 2004-09-09 20:36:58 Re: How to determine a database is intact?