Postgres Schema

[2004 IR Help]

By: Brian Lee - pulse1014

Postgres Schema

2005-03-11 17:57

I can't seem to query Postgres tables that are under a schema. It simply cannot see them. I can query tables in the public schema just fine.

 

ie SELECT * FROM Test.TableName - fails. Is there something extra I have to do? Is there something I am missing?

 

 

 

 

By: Brian Lee - pulse1014

RE: Postgres Schema

2005-03-11 18:04

Ok figured it out...

 

select * from "Test"."TableName"

[elzahr]

I've the same problem (6 years later) and still I haven't found another solution than writing the schema name before the tables in all the sql query inside the report. :/