Python is not able to read the file

41
November 24, 2021, at 9:10 PM

Let me rephrase the question. The equal signs are in the code, i hope that this is showed in the following lines of code. Apparently it does not read any of the tables that are stored in the sql database, which i can find however when I look at pgadmin. Do any of you have any idea what the reason could be that it cannot read any of the tables that are mentioned in this code. The strange thing is that I can read this code in pgadmin, however.

Thanks!

createjointable = '''SELECT( 
financial_data."Municipality",  
    financial_data."Average_income_per_working_person", 
    financial_data."Average_income_per_working_population",     
    financial_data."Average_income_per_household",
    fundadata_zip_converter_dropped_columns."postcode",
    fundadata_zip_converter_dropped_columns."place_name",
    fundadata_zip_converter_dropped_columns."county_name",
    fundadata_zip_converter_dropped_columns."state_name",
    fundadata."postcode")
FROM "fundadata"
INNER JOIN "fundadata_zip_converter_dropped_columns"
    ON "fundadata_zip_converter_dropped_columns"."postcode" = "fundadata"."postcode"
INNER JOIN "financial_data"
    ON  "fundadata_zip_converter_dropped_columns"."place_name" = "financial_data"."Municipality";'''
cursor.execute(createjointable);
    INNER JOIN financial_data
        ON financial_data."Municipality" "fundadata_zip_converter_dropped_columns"."postcode")'''

---------------------------------------------------------------------------
UndefinedTable                            Traceback (most recent call last)
<ipython-input-50-9d480b2d2e54> in <module>
     15     ON  "fundadata_zip_converter_dropped_columns"."place_name" = "financial_data"."Municipality";'''
     16 
---> 17 cursor.execute(createjointable);
UndefinedTable: relation "fundadata_zip_converter_dropped_columns" does not exist
LINE 12: INNER JOIN "fundadata_zip_converter_dropped_columns"
                    ^

How can this be solved?

READ ALSO
Goods list Data import using Excel Sheet

Goods list Data import using Excel Sheet

I'm new to Greater WMSI'm experimenting problems related to Importing Goods List using Excel file

53
PHP social contribution Yearly [closed]

PHP social contribution Yearly [closed]

Want to improve this question? Update the question so it focuses on one problem only by editing this post

39
Couchbase APIs, libraries or curl commands to copy data from one cluster to another

Couchbase APIs, libraries or curl commands to copy data from one cluster to another

I want to copy my data from one cluster of Couchbase to another cluster either via curl commands or using SDK librariesCould someone please let me know if is there any libraries/APIs available by which I can be do this

53