Thread: 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,
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