Обсуждение: What datatype should I use to store an IP Address?

Hi,

I'm using Varchar(16) to store an IP Address. PostgreSQL offers another datatypes to store IP's or it is OK to store in Varchar(16)?

Best Regards,

>On Thu, Mar 25, 2010 at 11:25 AM, Andre Lopes <lopes80andre@gmail.com> wrote:
> Hi,
>
> I'm using Varchar(16) to store an IP Address. PostgreSQL offers another
> datatypes to store IP's or it is OK to store in Varchar(16)?
>
> Best Regards,
>

Yes, just look here:
http://www.postgresql.org/docs/8.4/static/datatype-net-types.html

On Thu, 2010-03-25 at 11:28 +0100, Michał Pawlikowski wrote:
> > I'm using Varchar(16) to store an IP Address. PostgreSQL offers
> > another datatypes to store IP's or it is OK to store in Varchar(16)?
> >
> Yes, just look here:
> http://www.postgresql.org/docs/8.4/static/datatype-net-types.html

Alternatively, you can use ip4r:

 http://pgfoundry.org/projects/ip4r

"ip4 and ip4r are types that contain a single IPv4 address and a range
of IPv4 addresses respectively. They can be used as a more flexible,
indexable version of the cidr type."

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz