I need to update the row with the CSV filename and the time data was inserted into the database. I can use the below code to insert data from CSV into the database: with open('my.csv', 'r') as f: next(f) cur.copy_from(f,…
I'm using Postgresql,and I have a table named stock,this table has no index or id: open high low close volume datetime 383.97 384.22 383.66 384.08 1298649 2022-12-16 14:25:00 383.59 384.065 383.45 383.98 991327 2022-12-16 14:20:00 383.59 384.065 383.45 383.98 991327…
Can't do anything with Heroku using Rails and Postgres. It was working a few days ago and I upgraded from the Free plan to the Mini postgres plan and from the Free dyno to the Eco dyno. I get this…
I have three following tables: create table A ( a_id varchar(256) not null unique, a_name varchar(256) ); create table B ( b_id varchar(256) not null, b_a_id varchar(256) not null, b_name varchar(256), FOREIGN KEY (b_a_id) REFERENCES a (a_id) ); create table…
Following Sergey's example here, https://stackoverflow.com/a/60834163/1513027 I'm trying to create an anonymous DO block rather than a function. If I have the FETCH inside the block, it gives a syntax error, possibly wanting an INTO clause. And it doesn't matter whether…
I have a table named assets: create table assets ( id bigint primary key, name varchar(255) not null, value double precision not null, business_time timestamp with time zone, insert_time timestamp with time zone default now() not null ); I am…
Using psycopg2, I could write large results as CSV using copy_expert and a BytesIO buffer like this with pandas: copy_sql = "COPY (SELECT * FROM big_table) TO STDOUT CSV" buffer = BytesIO() cursor.copy_expert(copy_sql, buffer, size=8192) buffer.seek(0) pd.read_csv(buffer, engine="c").to_excel(self.output_file) However, I…
Can you please tell me how can I get following result? Table I have is: create table as tbl ( event_id integer, payor varchar ) payor and event_id both have duplicates. an event may contain more than 2 payor as…
I am using a function REGEXP_REPLACE within SQL to generate a slug value from name column UPDATE tag SET slug = LOWER(REGEXP_REPLACE( REGEXP_REPLACE('Team Building 2022', '^[^A-Za-z]+|[^A-Za-z]+$', '', 'g'), '[^A-Za-z]+|(?<=[a-z])(?=[A-Z])', '-', 'g') ); But I get: team-building Result I want is:…
I'm making a competitive two player game and after each game I store a record of that game that includes the score, player names and the date. I would like that if one of the users deletes their account the…