Run query: ERROR [HY000] Server error [SQL state: 42P01]: relation "liverpool" does not exist (Character 15)

[julio.magaia]

Hi Everyone, please assist me here

I have a database table Liverpool in Postgresql which contains names,number, surname and it is populated.

I then downloaded the ODBC File from CData for postgreSQL

I added the activity connect to database and in configure connection under Data Source I selected “Microsoft ODBC Data Source” and in details under Data Source Specification I entered “CData PostgreSQL Source” I then entered uer name and password fields.

When I tested the connection Test was successful.

I added Run query, Output Data Table, Write Line
under run query i inputed “Select * from Liverpool”

Now when I run this I get the error:
Run query: ERROR [HY000] Server error [SQL state: 42P01]: relation “liverpool” does not exist (Character 15)