DHara: types - PostgreSQL convert column from inet to text -

Tuesday 15 March 2011

I want to change the type of column from inet to text >. Therefore, I execute:

  optional table table optional column type text;

But then I found out that the mask was added for all the values, for example: 192.168.100.141 - & gt; 192.168.100.141/32 . "post-text"

To remove just IP address Use:

Alternate table table by using optional column type host (call);

DHara