Received: from hotmail.com (law2-f129.hotmail.com [216.32.181.129]) by hub.org (8.9.3/8.9.3) with SMTP id OAA63438 for ; Mon, 8 Nov 1999 14:38:30 -0500 (EST) (envelope-from dziablo@hotmail.com) Received: (qmail 91570 invoked by uid 0); 8 Nov 1999 19:37:49 -0000 Message-ID: <19991108193749.91569.qmail@hotmail.com> Received: from 207.96.139.27 by www.hotmail.com with HTTP; Mon, 08 Nov 1999 11:37:47 PST X-Originating-IP: [207.96.139.27] From: "Frederic boucher" To: pgsql-sql@postgresql.org Subject: parser :parse error Date: Mon, 08 Nov 1999 11:37:47 PST Mime-Version: 1.0 Content-Type: text/plain; format=flowed Hi, I'm trying to create a table with a default value for a field that containt an 's ... And the server always tell me : Error : parser: parse error at or near "s" my create looks like : create table tablename ( thefield varchar(50) default 'Fred''s car' ); Any suggestion? PS: This is more a linux question... but.. If I have a big file that contains all my sql to create my tables structure. I want to run it by doing "\i filename" but it scroll so fast I can't see when there is error... is there a way to do a kind of "pipe into less" \fb ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com