Inserting with empty values in PostgreSQL causes error

Question

My table has three columns, but I'm only using one for most rows.

I'm trying to do a basic insert in PSQL, like so:

grouper=> INSERT INTO master_list VALUES ('Ebay',,);

But I'm getting a syntax error:

ERROR:  syntax error at or near ","
LINE 1: INSERT INTO master_list VALUES ('Ebay',,);
                                               ^

Any advice or suggestions welcome!

Answer 1

Try

INSERT INTO master_list VALUES ('Ebay',null,null);

or

INSERT INTO master_list (fieldname) VALUES ('Ebay');