Re: SQL View to PostgreSQL View

On Sunday, February 26, 2012 10:50:16 am Rehan Saleem wrote:
> Hi ,
> I am trying to convert sql
> view to postgresql view but i am getting the
> following error i dont know how
> to handle dbo.
> in postgresql and when i remove dbo. from table name then view got created
> but it does not show any data, while this is working perfectly fine in
> sql, here is my code and error details 

> 
> i am getting this error , how can i fix this.
> 
> ERROR:  schema "dbo" does not exist
> LINE 15:  from  dbo.kbsites a inner join dbo.kbsites b on a.chr=b.chr
>                 ^
> 
> ********** Error **********
> 
> ERROR: schema "dbo" does not exist
> SQL state: 3F000
> Character: 761

Do you in fact have a schema dbo?
If so can you access the schema and table using some other method, for instance 
using psql?


-- 
Adrian Klaver
adrian.klaver@gmail.com