Postgres Pro
Downloads
Home   >   mailing lists

Re: bigint to ipaddress - Mailing list pgsql-general

From Camilo Sperberg
Subject Re: bigint to ipaddress
Date
Msg-id f05190a90908090542w3840abd6w430d0dfae2995b1b@mail.gmail.com
Whole thread Raw
In response to bigint to ipaddress  ("Mindaugas G." <mindaugas@biovela.lt>)
List pgsql-general
Tree view
There is no such thing as converting a bigint into an text ip address, unless you make it xD Google for "postgres INET_ATON" (INET_ATON is mysql's ip-to-int)

However, there are datatypes in postgres which allow you to work directly with ips and networks:
http://www.postgresql.org/docs/7.4/interactive/datatype-net-types.html

Greetings ;)

On Sun, Aug 9, 2009 at 05:44, Mindaugas G. <mindaugas@biovela.lt> wrote:
Hi,

googling few days with no success,
for example I have db with ip_src etc ant its data type bigint,
how must look select query what I can see ip address (int) instead of bigint?




--
Mailed by:
UnReAl4U - unreal4u
ICQ #: 54472056
www: http://www.chw.net/

pgsql-general by date:

Previous
From: "Abraham, Danny"
Date:
Subject: Re: PG fails on Windows Server 2008: could not reattach to shared memory ... : 487
Next
From: Kobus Wolvaardt
Date:
Subject: Postgres memory question