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(dot)klaver(at)gmail(dot)com