I am trying to write a script that creates a new table in my Postgres database and copies an existing csv file to that table using the psycopg2 library. To be clear, I am strictly trying to do this with psycopg2, not using other methods like psql.exe or ogr2ogr. So far, I can connect, create ..
Category : postgresql
I am getting a JSON response from a server, in order to arrange and clean the data I am restructuring the response. When I send the data back to a Postgresql DB, I get an error for entries like place’s I understand that in SQL it should be written as place”s and not as place’s ..
I have a table with fields channel_id, message_id and status. Each row in this table represents a message from a channel. The status can be SENT, DELIVERED or SEEN. When a user sends a message, a row is added to this table with the status SENT. When a user reads that message, another row is ..
This should be fairly simple, I’ve done it before, but I am stumped. I have a postgresql server set up on one machine on my internet and I am trying to access it from a different machine on the same network. I can connect to the database when on the same machine using localhost but ..
I get an error password authentication failed for user "usertodoproject". Really losing my patience, so far I have done couple of new databases and used fpr example this ALTER USER todouser WITH PASSWORD ‘todo’; it did not help either. Any ideas? *EDIT IT IS DOCKER-COMPOSE FAULT NOT SETTINGS. App runs without docker. settings.py DATABASES = ..
I started learning PostgreSQL and just got to where I need to set the transaction isolation level. I see plenty of material explaining how to set it, but I still can’t figure out why I need to do this. I want to create a database, and when executing the code below, I get an error ..
I have run into a problem. I have this SQL query (for RedShift) in AirFlow: SQL_QUERY = (f""" … WITH all_unputs AS ( SELECT fct_dc.collect_project_id AS fct_dc_collect_project_id, replace(inp.text, ‘},{‘, ‘},-{‘) AS text, … """) Somewhere in place ‘},{‘, ‘},-{‘ he starts to swear that the syntax is not correct and on closed brackets: f-string: single ..
I am trying to connect to a remote PostgresSQL database using the psycopg2 library in Python. So far, I have verified that I can connect and use my cursor to perform a simple query on an existing table: import psycopg2 conn = psycopg2.connect(dbname=’mydb’, user=’postgres’, password=’mypassword’, host=’www.mydbserver.com’, port=’5432′, sslmode=’require’) cur = conn.cursor() cur.execute(‘SELECT * FROM existing_schema.existing_table’) ..
I am using the script that contains the code below query = """ALTER TABLE table_name ALTER COLUMN column_name NUMERIC (22,6);""" self.cursor.execute(query) self.connection.commit() but i get error below psycopg2.errors.SyntaxError: syntax error at or near "NUMERIC" Have you encountered error like this? I have searched nothing is out on the internet. PS: I have used DECIMAL instead ..
jsonb column text_results contains values in the following form : {‘Name’ : ‘john doe’ , ‘id’ : ‘123’} On querying Select text_results->>’Name’ as Name from user_master or Select json_extract_path_text(text_results::json,’Name’) as name from user_master it always return None without any error even though values are present. Need help with rectifying the error or any other way ..
Recent Comments