I have a csv file which contains some data I want to use in a psql query. I am currently able to import the data from the csv into a table in my db, but I want to make the query without saving the data in my db. How can I do this?
I want to be able to do something like this:
SELECT * FROM my_table WHERE id IN (my_csv_data)