On Wed, 2004-07-14 at 17:34, Jodi Kanter wrote: > Can field specific defaults easily be added to a table that is already > in existence and has data in it? I cannot seem to locate the correct > ALTER command in any of my books.
ALTER TABLE table ALTER COLUMN column SET DEFAULT expression -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== "God is faithful, by whom ye were called unto the fellowship of his Son Jesus Christ our Lord." I Corinthians 1:9 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
