On Sat, 28 Nov 2009, Bruce Momjian wrote: Rob Napier wrote: I suggest that you combine the two ideas: INSERT INTO pg_mug VALUES('coffee', 'water', 'sugar', 'cream'); And BEGIN; CREATE TABLE postgresql (mug_id SERIAL); COMMIT; You mean: BEGIN; CREATE TABLE pg_mug (contents TEXT); INSERT INTO pg_mug VALUES('coffee', 'sugar', 'cream'); COMMIT; ? I don't think "water" makes sense unless you are making instant coffee, which I think is atypical. Ummm ... last I checked, that query will fail with too many fields? :)
Rob Napier wrote: I suggest that you combine the two ideas: INSERT INTO pg_mug VALUES('coffee', 'water', 'sugar', 'cream'); And BEGIN; CREATE TABLE postgresql (mug_id SERIAL); COMMIT; You mean: BEGIN; CREATE TABLE pg_mug (contents TEXT); INSERT INTO pg_mug VALUES('coffee', 'sugar', 'cream'); COMMIT; ? I don't think "water" makes sense unless you are making instant coffee, which I think is atypical.
I suggest that you combine the two ideas: INSERT INTO pg_mug VALUES('coffee', 'water', 'sugar', 'cream'); And BEGIN; CREATE TABLE postgresql (mug_id SERIAL); COMMIT;
INSERT INTO pg_mug VALUES('coffee', 'water', 'sugar', 'cream');
BEGIN; CREATE TABLE postgresql (mug_id SERIAL); COMMIT;
pgsql-advocacy by date:
Соглашаюсь с условиями обработки персональных данных