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
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 |