Received-SPF: pass (google.com: domain of adrian.klaver@gmail.com designates
	10.68.134.41 as permitted sender) client-ip=10.68.134.41;
From: Adrian Klaver <adrian.klaver@gmail.com>
To: pgsql-sql@postgresql.org,
 Rehan Saleem <pk_rehan@yahoo.com>
Subject: Re: SQL View  to PostgreSQL View
Date: Mon, 27 Feb 2012 06:13:59 -0800
User-Agent: KMail/1.13.5 (Linux/2.6.32-38-generic; KDE/4.4.5; i686; ; )
References: <1330282216.75125.YahooMailNeo@web121605.mail.ne1.yahoo.com>
In-Reply-To: <1330282216.75125.YahooMailNeo@web121605.mail.ne1.yahoo.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <201202270613.59790.adrian.klaver@gmail.com>

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