I have created model in django for my database. After trying to add data to table I got this error: ` lib/python3.10/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) psycopg2.errors.UndefinedColumn: column "source_id_id" of relation "service_approval_domains" does not exist LINE 1: …domains" ("domain", "created_at", "retrieved_at", "source_id… ^ I am not really sure where is the problem… Read More psycopg2.errors.UndefinedColumn: column "source_id_id" of relation "service_approval_domains" does not exist

I have a database and have added an additional column ‘team’ so it looks like this date | forename | surname | team —————————————– 1/1/01 | james | smith | 2/2/02 | paul | jones | 3/3/03 | steven | bradley | I want to add an entry to the team column from each, chosen… Read More Update column in rows with variable for each row

I am writing part of a Python program where I query a PostgreSQL table called stockNames and use the results to print information based on user input. stockNames has the following layout: company stockTicker industry Starbucks SBUX Food/Beverage … I also have a series of Python print statements as follows (brief variable assignments shown as… Read More Trying to use Python variable names in psycopg2 queries

Disclaimer that I’m highly aware there’s a better way to word the question, if someone wants to suggest a better way I’d be happy to change it I’ve been working with DynamoDB for the past 4 years and now I’m switching one of my tables over to postgreSQL. I’ve been working with the psycopg2 python… Read More How to omit certain parts of a SQL query

Intro I am writing a piece of python code that uses pcycopg2, pandas and datetime that retrieves information from a PGAdmin database, which filters the data to the last 14 days of activity. The columns I am pulling from the database are: id (Unique Number), createdby (Name), created (Date) I pull all of that information… Read More Error when applying a timeframe mask to dataframe

I am using Python + Psycopg2 to insert an array of texts. elems column is of type text[]. a = ["A ”B” C"] cursor.execute(f"""\ INSERT INTO table(elems) \ VALUES (ARRAY{a}::text[]) \ """) Error: column "A ”B” C" does not exist The error above is due to the double quotes from Python list. Using a database… Read More Psycopg2 – Error during insert due to double quotes

In Python I’ve connected to a Postgres database using the following code: conn = psycopg2.connect( host = "localhost", port = "5432", database = "postgres", user = "postgres", password = "123" ) cur = conn.cursor() I have created a table called departments and want to insert data into the database from a CSV file. I read… Read More Inserting csv file into a database using Python

I’m trying to create a class method that can run some code after its execution. In pytest we have this functionality with fixtures: @pytest.fixture def db_connection(conn_str: str): connection = psycopg2.connect(conn_str) yield connection connection.close() # this code will be executed after the test is done Using this fixture in some test guarantees that connection will be… Read More Using yield to run code after method of function execution

Good afternoon, faced with such a situation. I wrote a query to get data from postgresql and it outputs the following, i get a list of tuples: [datetime.date(2022, 8, 12), datetime.time(10, 8, 1), ‘object’, ‘Kos’, ‘login’, ‘number’, ‘password’, None, ‘client’, ‘no’, ‘no’, ‘no’, ‘S5’] but I need to turn the date and time into the… Read More How to write a query correctly to get the date and time in psycopg2?

I have read many answers to this same question, but haven’t seen anything that works for me. I have a very basic app just to test things (in app.py and database.py). I’m using ElephantSQL, psycopg2-binary and have checked – the table on ElephantSQL is made from this code, but cannot insert from here. I can… Read More Getting 'TypeError: not all arguments converted during string formatting' in Python PostgreSQL code (other answers not fixing it)