Postgres Pro
Downloads
Home   >   mailing lists

Re: What datatype should I use to store an IP Address? - Mailing list pgsql-general

From Michał Pawlikowski
Subject Re: What datatype should I use to store an IP Address?
Date
Msg-id 217ea9ed1003250328i565eb0fax1084c59c130cf8ed@mail.gmail.com
Whole thread Raw
In response to What datatype should I use to store an IP Address?  (Andre Lopes <lopes80andre@gmail.com>)
Responses Re: What datatype should I use to store an IP Address?  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List pgsql-general
Tree view 
>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

pgsql-general by date:

Previous
From: Andre Lopes
Date:
Subject: What datatype should I use to store an IP Address?
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: What datatype should I use to store an IP Address?