From: Rehan Saleem [mailto:pk_re...@yahoo.com]
Sent: Sunday, February 26, 2012 1:50 PM
To: pgsql-sql@postgresql.org
Subject: SQL View to PostgreSQL View
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
Hi Rehan,
Whilst I'm not sure what you exactly mean with ', while this is
working perfectly fine in sql,..',
it's kind of odd that you get result when you execute the sql.
I'd suggest looking at your search_path (show search_path), which
normally resolves to 'user', 'public';
If you do h
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
