I'm (1) new to postgres & (2) trying to "convert" the sample db found in "The Practical SQL Handbook" Bowman, et al. to postgres. When trying to create the following table I get "parser: parse error at or near 'null'" create table authors ( au_id char(11) not null, au_lname varchar(40) not null, . . . zip char(5) null ); The table creation works fine twith the NOT NULL but won't work with the NULL. NULL is supported isn't it? I can't see where I'm making a syntax error. Got me stumped. TIA. ........Bill Sneed Prospect, Maine......