Thread: inet_aton in mysql, how to convert it to postresql?

inet_aton in mysql, how to convert it to postresql?

From
azah azah
Date:
Hi,
I need some help to solve a problem regarding transfer from mysql to postresql.
Previously in mysql, we use inet_aton such below:

select inet_aton(namatable.host) from ...

how can i do in postresql??

-azah

Re: inet_aton in mysql, how to convert it to postresql?

From
Christopher Kings-Lynne
Date:
> select inet_aton(namatable.host) from ...
>
> how can i do in postresql??

Try these:

http://www.postgresql.org/docs/7.4/static/functions-net.html

You need to be using the 'inet' or 'cidr' types.

Chris