Control PhoneNumber Via SQL

From: tango ward <tangoward15(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Control PhoneNumber Via SQL
Date: 2018-05-15 09:10:41
Message-ID: CAA6wQLKUGns3pBaukYHnkXTKmMVadrtgprUMhV+R0iQQy86chQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Sorry for asking question again.

I would like to know if it is possible to control the phone number in SQL
before inserting it to the destination DB?

I have a model in Django:

class BasePerson(TimeStampedModel):
phone_number = PhoneNumberField(max_length=50, verbose_name=_(u'phone
number'), blank=True)

The data for phone number that I am migrating doesn't have country code. I
want to determine first if the number has country code in it, if it doesn't
then I will add the country code on the number before INSERTING it to the
destination database.

Any suggestion will be highly appreciated.

Thanks,
J

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hamann.w 2018-05-15 09:46:31 Re: Control PhoneNumber Via SQL
Previous Message Maxim Boguk 2018-05-15 09:06:38 Re: found xmin from before relfrozenxid on pg_catalog.pg_authid