How would one do a statement in a create table structure such that a
logical field was defined with a default value a user could change with
populating that table?
Jude DaShiell wrote
> How would one do a statement in a create table structure such that a
> logical field was defined with a default value a user could change with
> populating that table?
Not syntax checked, look at the create table documentation if it doesn't
work...
CREATE TABLE tbl (
bool_field Boolean DEFAULT true
);
Insert into tbl (bool_field) values (false);
David J.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/logical-fields-with-defaults-tp5816951p5816994.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.