pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
insert with "Fred's car!"
2+ messages / 2 participants
[nested] [flat]

* insert with "Fred's car!"
@ 1999-11-05 11:51 Frederic boucher <dziablo@hotmail.com>
  1999-11-05 20:41 ` Re: [SQL] insert with "Fred's car!" Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Frederic boucher @ 1999-11-05 11:51 UTC (permalink / raw)
  To: pgsql-sql

Hi,

A simple question :

How can I insert a values like

insert into tablename values('Fred's car');

I've tried "Fred's car", 'Fred''s car', etc but nothing work.. is there a 
"\something" to pass it like

'Fred\c' car'

?

THanks
\fb

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] insert with "Fred's car!"
  1999-11-05 11:51 insert with "Fred's car!" Frederic boucher <dziablo@hotmail.com>
@ 1999-11-05 20:41 ` Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 1999-11-05 20:41 UTC (permalink / raw)
  To: Frederic boucher <dziablo@hotmail.com>; +Cc: pgsql-sql

> Hi,
> 
> A simple question :
> 
> How can I insert a values like
> 
> insert into tablename values('Fred's car');
> 
> I've tried "Fred's car", 'Fred''s car', etc but nothing work.. is there a 
> "\something" to pass it like

Should work.


	test=> create table test (x text);
	CREATE
	test=> insert into test values ('asdf''fred');
	INSERT 18569 1
	test=> select * from test;
	     x     
	-----------
	 asdf'fred
	(1 row)


-- 
  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, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-11-05 20:41 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-11-05 11:51 insert with "Fred's car!" Frederic boucher <dziablo@hotmail.com>
1999-11-05 20:41 ` Bruce Momjian <maillist@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox