Somebody give the man a cookie! Joe, when you create the table, use the serial type: CREATE TABLE tableLogfileList( logfile_id SERIAL PRIMARY KEY, logfile_path TEXT NOT NULL, logfile_size INTEGER NOT NULL, logfile_time INT8 NOT NULL, logfile_md5 CHAR(32), logfile_errors INT2) Then, to add data, just ignore the id like this: INSERT INTO tableLogfileList ( logfile_path, logfile_size, logfile_time, logfile_md5, logfile_errors ) VALUES ( '/usr/local/logs/new-reports.ibeam.com/vyvx_williamsenl/NetShow.010401-01040 2.log' 11171, 988365240, 'a09ff0a4b11142d03ea940e83a94c82a', 0) See some techdocs on Postgresql (good choice): http://www.postgresql.org/idocs/index.php?datatype.html#DATATYPE-NUMERIC As you can tell, I prefer real world examples :) Troy