Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Modifying table variables

Status
Not open for further replies.

chedder123

Programmer
Jan 2, 2003
7
US
Ok... I feel really dumb now. I'm going to buy a book. I believe this is the command, however it's not working.

ALTER TABLE leads ALTER created SET timestamptz DEFAULT 'now' NOT NULL

ALTER TABLE leads ALTER export_counter SET int4 DEFAULT '0' NOT NULL


I already have a populated table and just wanted to change those two variables so it won't just be null everytime a new row is added. Can anyone check the syntax on that and tell me what I should be doing?

Thanks,
Chad
 
Hi chedder123

My apology for accidentially refer to you as nestorjb in my other post. Please refer to your other post to see my response.

LelandJ
Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top