Re: [SQL] parser :parse error

Works on current tree.  Try 6.5.3.


> 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
> 
> ************
> 
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026