Postgres Pro
Downloads
Home   >   mailing lists

Re: psycopg2.DataError: invalid input syntax for integer: "" - Mailing list pgsql-general

From David G. Johnston
Subject Re: psycopg2.DataError: invalid input syntax for integer: ""
Date
Msg-id CAKFQuwZwoQK4PXmGh5Y8CCkPgwSqZs6hKLRsg=UB=DSH3tMU4Q@mail.gmail.com
Whole thread Raw
In response to Re: psycopg2.DataError: invalid input syntax for integer: ""  (tango ward <tangoward15@gmail.com>)
List pgsql-general
Tree view
On Mon, May 7, 2018 at 12:28 AM, tango ward <tangoward15@gmail.com> wrote:
I think I've found the culprit of the problem.

I have a field which is varchar from the source DB while on the destination DB its integer.

Reading the documentation: http://www.postgresqltutorial.com/postgresql-cast/ but it gives me error `psycopg2.DataError: invalid input syntax for integer: ""`


You haven't asked a question and your statement is unsurprising to me.  Are you good now or do you still harbor confusion?

David J.
​

pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: Add schema to the query
Next
From: Adrian Klaver
Date:
Subject: Re: psycopg2.DataError: invalid input syntax for integer: ""