Received: from univaq.it (mailhost.univaq.it [192.150.195.13]) by hub.org (8.9.1/8.9.1) with ESMTP id KAA17949 for ; Mon, 7 Dec 1998 10:35:13 -0500 (EST) (envelope-from mancinel@univaq.it) Received: from brutus by univaq.it (8.8.8+Sun/SMI-SVR4) id QAA12900; Mon, 7 Dec 1998 16:34:12 +0100 (MET) Date: Mon, 7 Dec 1998 16:31:31 +0100 (MET) From: Fabio Mancinelli X-Sender: mancinel@brutus To: pgsql-sql@postgresql.org Subject: ' escape Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hello all I have a question. When I create a table I cannot use any escape to put a ' character in the default field definition. CREATE TABLE Test (name varchar(128) default 'Something with '' into'); Fails. I've tried also other alternatives : default "Something with ' into" default "Something with '' into" default 'Something with \' into' default 'Something with \27 into' default 'Something with \0x27 into' Everything fails. How can I set a default with a string containing a ' ? Thank you all. Bye ---------------------------------------------------------------------------- Greetings from Fabio Mancinelli E-Mail : mancinel@univaq.it Computer Science Student xenon@olografix.org University of L'Aquila WWW : http://univaq.it/~mancinel (PGP Public Key available) http://www.olografix.org/xenon A.L.U. Member