Instruction
Amazing! What about using DEFAULT for all columns? You can use a statement like this:
INSERT INTO all_defaults_table VALUES (DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
Once again, however, PostgreSQL allows you to use a shorter query:
INSERT INTO all_defaults_table DEFAULT VALUES;
Using DEFAULT for every table column is a very rare case, so we don't need to discuss it in detail. Just remember that you can use this syntax if needed.
Exercise
Click to continue.



