Error in Table Creation
| От | Rajnish Vishwakarma |
|---|---|
| Тема | Error in Table Creation |
| Дата | |
| Msg-id | CADH9T5OTEHqNtV41ExPixoQEvc4M2tfZc0w2oUsYw3i60XWXMQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Error in Table Creation
Re: Error in Table Creation |
| Список | pgsql-general |
I am creating dynamically table in PostgreSQL using psycopg2 by passing the below 2 strings as column names:
and
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
Thanks
Rajnish Vishwakarma
'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 onceThe above columns are of type TEXT ...also it may be Numeric Type in future.
Require assistance from Postgres team on the above error.
Rajnish Vishwakarma
В списке pgsql-general по дате отправления: