This is exactly what I was doing. I use PostgreSQL Manager Pro. The tool
covert all my column name and table name in the double quote. So I have all
my column/table/function created in upper case (Oracle habit). Now, I have
to quote all of them.
I should stay with psql, I guess. :-)
Thanks! At le
Ron Johnson <[EMAIL PROTECTED]> writes:
> On Fri, 2003-07-25 at 07:28, Andrew Sullivan wrote:
>> The docs have it in a footnote:
>> http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-syntax.html#FTN.AEN1031
>>
>> PostgreSQL's approach is backwards from the standard.
> Is there any firm discu
On Friday 25 July 2003 02:37 am, Thomas Kellerer wrote:
> Terence Chang schrieb:
> > I am still getting the error. would this matter with 7.3.3 on windows
> > with cygwin?
>
> From my experience I'd never user quotes at any place (neither during
> creation of the table nor in the SELECT, UPDATE st
On Fri, 2003-07-25 at 07:28, Andrew Sullivan wrote:
> On Thu, Jul 24, 2003 at 04:34:26PM -0700, Terence Chang wrote:
> > All:
> >
> > I don't remember I even seen a document saying PostgreSQL are case
> > sensitive. I just figure out that my column name are case
>
> The docs have it in a footnote
On Thu, Jul 24, 2003 at 04:34:26PM -0700, Terence Chang wrote:
> All:
>
> I don't remember I even seen a document saying PostgreSQL are case
> sensitive. I just figure out that my column name are case
The docs have it in a footnote:
http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-syntax.htm
Terence Chang schrieb:
I am still getting the error. would this matter with 7.3.3 on windows with
cygwin?
From my experience I'd never user quotes at any place (neither during creation
of the table nor in the SELECT, UPDATE statements). All DBMS I know behave like
Postgres. So if you never quote
On Thu, 24 Jul 2003, Terence Chang wrote:
> I am still getting the error. would this matter with 7.3.3 on windows with
> cygwin?
>
> My query only works when I quote the field. Also I have to always use the
> schema name in the where clause. Is there any way that I can set default
> schema to "app
I am still getting the error. would this matter with 7.3.3 on windows with
cygwin?
My query only works when I quote the field. Also I have to always use the
schema name in the where clause. Is there any way that I can set default
schema to "app_v08" but not public? Thank you very much!
My table u
