Skip to content
Snippets Groups Projects
user avatar
Bruce Momjian authored
The attached patch allows views to have default values. You can't
specify a default value within a CREATE VIEW statement, it must be
done using ALTER TABLE ... ALTER COLUMN ... SET DEFAULT after the
view has already been created. Most of the hard work was done by
Tom Lane, I just patched pg_dump and updated the documentation.

Neil Conway <neilconway@rogers.com>
19b31e07
History
Name Last commit Last update
..
abort.sgml
allfiles.sgml
alter_database.sgml
alter_group.sgml
alter_table.sgml
alter_user.sgml
analyze.sgml
begin.sgml
checkpoint.sgml
close.sgml
cluster.sgml
comment.sgml
commit.sgml
copy.sgml
create_aggregate.sgml
create_constraint.sgml
create_database.sgml
create_domain.sgml
create_function.sgml
create_group.sgml
create_index.sgml
create_language.sgml
create_operator.sgml
create_rule.sgml
create_sequence.sgml
create_table.sgml
create_table_as.sgml
create_trigger.sgml
create_type.sgml
create_user.sgml
create_view.sgml
createdb.sgml
createlang.sgml
createuser.sgml
current_date.sgml
current_time.sgml
current_timestamp.sgml
current_user.sgml
declare.sgml
delete.sgml
drop_aggregate.sgml
drop_database.sgml
drop_domain.sgml
drop_function.sgml
drop_group.sgml
drop_index.sgml
drop_language.sgml
drop_operator.sgml
drop_rule.sgml
drop_sequence.sgml
drop_table.sgml
drop_trigger.sgml
drop_type.sgml
drop_user.sgml
drop_view.sgml
dropdb.sgml
droplang.sgml
dropuser.sgml
ecpg-ref.sgml
end.sgml
explain.sgml
fetch.sgml
grant.sgml
initdb.sgml
initlocation.sgml
insert.sgml
ipcclean.sgml
listen.sgml
load.sgml
lock.sgml
move.sgml
notify.sgml
pg_config-ref.sgml
pg_ctl-ref.sgml
pg_dump.sgml
pg_dumpall.sgml
pg_restore.sgml
pgaccess-ref.sgml
pgtclsh.sgml
pgtksh.sgml
postgres-ref.sgml
postmaster.sgml
psql-ref.sgml
reindex.sgml
reset.sgml
revoke.sgml
rollback.sgml
select.sgml
select_into.sgml
set.sgml
set_constraints.sgml
set_session_auth.sgml
set_transaction.sgml
show.sgml
truncate.sgml
unlisten.sgml
update.sgml
vacuum.sgml
vacuumdb.sgml