What datatype should I use to store an IP Address?

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