| 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: | Whole Thread | Raw Message | 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 |