One Star

Schema does not exist


Am using Talend Open Source 6.1 with Postgres 9.2 and trying to run a small transoframtion from a database but ma facing the following error:

Exception in component tPostgresqlInput_1
org.postgresql.util.PSQLException: ERROR: schema "t_from_csv" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse( org.postgresql.core.v3.QueryExecutorImpl.processResults(
at org.postgresql.core.v3.QueryExecutorImpl.execute(
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
at demo_1.demo_01_0_1.demo_01.tPostgresqlInput_1Process(
at demo_1.demo_01_0_1.demo_01.tFileInputDelimited_1Process(
at demo_1.demo_01_0_1.demo_01.runJobInTOS(
at demo_1.demo_01_0_1.demo_01.main(

I found this posting:, but to be honest I didn't understand what is exactly meant?

Any Idea pls.?
Many Thx!
Four Stars

Re: Schema does not exist

In postgres you have a database which can have more then 1 schema (think about each schema like a folder)
if you want to insert a table in such a folder, you either connect to this schema by Setting the right one in the postgresconnectionsettings,
or you write 'insert (...columnlist...) values (...valuelist..) into "mySchema"."myTable"' as statement´, qualifing the table with the schema where  the table belongs to.
One Star

Re: Schema does not exist

Thx for the reply!
The point is that am retrieving data from a data base table not adding data... the generated SQL Query from the mapping:
FROM \"test_1\".\"us_states_in_test\""

The structure of the DB in postgres looks like following:

Am defening the right Scheman in the connection and selecting the right table wich is: "us_states_in_test"
Connection and the rest looks all fine. but the error is still showing up. I think the problem is the /public Schema/Folder.. this is a default Schema which is provided by postgres. I could create a new Schema in postgres but the issue will stya the same - I suppose.
Any other Idea?
Many Thanks!
One Star

Re: Schema does not exist

Hi Guys,
I fixed the issue... the sloution was that I just changed the SQL Qeury to:
FROM "us_states_in_test";

Thanks for the support!