Tag Info

New answers tagged


In Postgres (tested with v9.3) you can use the dedicated inet data type, to store IPv4 addresses with only 7 bytes (or IPv6 with 19 bytes) and with automatic integrity checks and dedicated functions and type casts etc. Schema The translated schema could look like this: CREATE TABLE log ( id serial PRIMARY KEY , dst_port int , src_ip inet , dst_ip inet ...

Top 50 recent answers are included