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?
Bye
--
Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project