How to QUERY (SQL) in QGIS DB Manager?

Ask Question

Asked 3 years, 11 months ago

Active 3 years, 11 months ago

Viewed 851 times

This is my first time using DB Manager to store data. The Import/Export them was easy. My point is, when i try to run a QUERY it returns this error!

I´m using QGIS 2.18 , PostgreSQL 9.4

ahmadhanb

32.8k5 gold badges36 silver badges82 bronze badges

asked Mar 1 '17 at 9:14

Paulo Martinho

7174 silver badges16 bronze badges

add a comment |

1 Answer 1

When you're using capital letters in names of tables or columns you need to place it in " ". Postgres is case sensitive

answered Mar 1 '17 at 9:22

Jendrusk

2,4576 silver badges15 bronze badges

:) If it helped mark answer as correct and/or upvote :) – Jendrusk Mar 1 '17 at 10:06

add a comment |

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy