Re: REFERENCES error message complaint, suggestion

From: Enrico Weigelt <weigelt(at)metux(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: REFERENCES error message complaint, suggestion
Date: 2004-03-04 17:49:26
Message-ID: 20040304174925.GC17390@nibiru.metux.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [2004-03-04 11:24:11 -0500]:

<snip>
> Double quotes are for names (identifiers). Single quotes are
> for string literals (constants).

BTW: is this general SQL syntax or just PostgeSQL ?

mysql does no distinction (which is IMHO very unclean), and it gets
even worse since mysqldump's output does it exactly the wrong way:
identifiers in '' and string constants in "" ...

cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT services

phone: +49 36207 519931 www: http://www.metux.de/
fax: +49 36207 519932 email: contact(at)metux(dot)de
cellphone: +49 174 7066481
---------------------------------------------------------------------
-- DSL-Zugang ab 0 Euro. -- statische IP -- UUCP -- Hosting --
---------------------------------------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2004-03-04 17:49:49 Re: clarification of postgres limitations
Previous Message Phil Campaigne 2004-03-04 17:45:43 Re: Setting up Postgresql on Linux