kandi X-RAY | postgresguide.com Summary
kandi X-RAY | postgresguide.com Summary
postgresguide.com
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of postgresguide.com
postgresguide.com Key Features
postgresguide.com Examples and Code Snippets
Community Discussions
Trending Discussions on postgresguide.com
QUESTION
I am new to SQL and I was wondering if there was any way to search a table for instances with values from a column of an external table (csv file). To explain that in a clearer manner, this is what I'm working on: If a column in the csv file contains latitudes and another column contained longitudes; I want to search a table that contains information about several locations, with their Latitudes and Longitudes specified in the table.
I want to retrieve the information about that particular location with Latitudes and Longitudes as input from a csv file.
Would it look something like this? :
...ANSWER
Answered 2017-Jul-13 at 17:01PostgreSQL does not support the LOAD DATA
syntax you're using. You'll need to use COPY
instead.
Your workflow should look more like:
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install postgresguide.com
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page