Re: Inet type how to?

It works for me for \copy (which uses inserts)

But yes, there is no way to convert text to inet, which is a pain. When it
annoys me sufficiently, I think I'll write text_inet wrapping inet_in...Or
just wait for someone else to do it (TODO, bruce? ;)

On Fri, 2 Jun 2000, Olivier PRENANT wrote:

> Yes, I know that; but even when I reload it, copy complains it can't
> convert 194.250.190.185 ( for example) to inet!
> 
> Regards
> On Fri, 2 Jun 2000, Alex Pilosov wrote:
> 
> > You cannot change column type without dropping/recreating the table.
> > 
> > On Fri, 2 Jun 2000, Olivier PRENANT wrote:
> > 
> > > Hi all,
> > > 
> > > I've had a table for years to keep radius connections to our NAS.
> > > 
> > > Not havin inet type, I typed ip_adress as text. Now, I'em trying to change
> > > this column type to no avail.
> > > 
> > > select inet(ip_addr)... : cannot cast type to inet
> > > 
> > > How can I change this column??
> > > 
> > > TIA
> > > 
> > > 
> > 
> 
>