Skip to main content

All Questions

Filter by
Sorted by
Tagged with
2 votes
0 answers
287 views

Convert SQL Query types to Python Types

I want to convert the data types of the results of a SQL query run using create_engine from SQLAlchemy to a Python object, save it as a CSV and than load into another SQL database, which may use a ...
Frederico Schmitt Kremer's user avatar
2 votes
5 answers
2k views

Append results from a query to the same result row in PostgreSQL - Redshift

I have a table, with 3 columns A, B , C - where A is not the primary key. We need to select the B, C pairs for each distinct A(group by A), and append the results at the end of the final result set. ...
ekta's user avatar
  • 1,620