Andreas 'ads' Scherbaum wrote:
> On Sat, 28 Nov 2009 17:57:38 -0500 (EST) Bruce Momjian wrote:
>
> > That highlights our multi-value INSERT too. :-) With proper wrap it
> > would be:
> >
> > BEGIN;
> > CREATE TABLE pg_mug (contents TEXT);
> > INSERT INTO pg_mug
> > VALUES('coffee'), ('sugar'), ('cream');
> > COMMIT;
> >
> > You can even add stirring:
> >
> > BEGIN;
> > CREATE TABLE pg_mug (contents TEXT);
> > INSERT INTO pg_mug
> > VALUES('coffee'), ('sugar'), ('cream');
> > -- stir
> > SELECT * FROM pg_mug ORDER BY random();
> > COMMIT;
>
> The mug is colored anyway, right now blue and black. Can/should we add
> some syntax highlighting?
Great idea --- colorful is good.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +