CREATE EXTENSION IF NOT EXISTS pg_libphonenumber; --Test phone number parsing select parse_phone_number('555-555-5555', 'US'); parse_phone_number -------------------- +1 555-555-5555 (1 row) --These two should produce errors because the number is too long. --Produces an error in pg-libphonenumber's code select parse_phone_number('555-555-5555555555', 'US'); ERROR: phone number '+1 5555555555555555' is too long DETAIL: National number is too long --Produces an error from libphonenumber select parse_phone_number('555-555-55555555555', 'US'); ERROR: unable to parse '555-555-55555555555' as a phone number DETAIL: National number is too long -- Do we get correct country codes? -- TODO: expand. select phone_number_country_code(parse_phone_number('+1-555-555-5555', 'USA')); phone_number_country_code --------------------------- 1 (1 row)