Select based on csv file values

Question

Is there any way to take a csv file with numerous values and feed these values into a postgres select statement. For example if i had a csv file called text.csv with values 1,2,3,4,5,6... is there a way for me to perform a select such as:

select * 
from table 
where id in (test.csv);

JosMac · Accepted Answer · 2016-12-14 15:38:36Z

2

There is a fdw-file - https://www.postgresql.org/docs/current/static/file-fdw.html - foreign data wrapper which allows you to use file as table.

Here is example - http://www.postgresonline.com/journal/archives/250-File-FDW-Family-Part-1-file_fdw.html

answered Dec 14, 2016 at 15:38

JosMac

2,3601 gold badge22 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JosMac Over a year ago

See in example - (after you create "foreign server" etc. as described) you will create so called "foreign table" and this table will behave as normal table in select. But data will be taken from file.

Keyur Shah · Accepted Answer · 2017-09-01 06:04:27Z

-1

Well this is how it can be done !

Select * from table where id in (
  select id from openrowset('MSDASQL'
               ,'Driver={Microsoft Text Driver (*.txt; *.csv)}'
               ,'select * from c:\test.csv')
  )

In case if your sql server is not enabled for Ad Hoc Distributed Queries, fire below sql first.

sp_configure 'show advanced options', 1;  
RECONFIGURE;
GO 
sp_configure 'Ad Hoc Distributed Queries', 1;  
RECONFIGURE;  
GO

Good Luck ! Keyur

answered Sep 1, 2017 at 6:04

Keyur Shah

1

1 Comment

user330315 Over a year ago

That is invalid SQL and invalid for Postgres as well (the only two tags on the question)

Collectives™ on Stack Overflow

Select based on csv file values

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related