I am creating dynamically table in PostgreSQL using psycopg2 by passing the
below 2 strings as column names:
'BAF7_X_X_During_soaking-__Temperature__difference_coil_to_coil_with_metal_temp_TC_load_in_PA_load'
and
'BAF7_X_X_During_soaking-__Temperature__difference_coil_to_coil_with_metal_temp_TC_load__in_TA_load'
And the above column names are not same ( both are different columns ) and
both the columns has string same till
*'BAF7_X_X_During_soaking-__Temperature__difference_coil_to_coil_with_metal_temp_TC_load__
.*
but i am getting errors as
Error:
Traceback (most recent call last):
File
"C:/Users/Administrator/PycharmProjects/untitled/table_creation_with_HDA_Data.py",
line 131, in <module>
cursor.execute(sqlCreateTable)
psycopg2.errors.DuplicateColumn: column
"BAF7_X_X_During_soaking-__Temperature__difference_coil_to_coil_"
specified more than once
The above columns are of type TEXT ...also it may be Numeric Type in future.
Require assistance from Postgres team on the above error.
Thanks
Rajnish Vishwakarma
