Bryan Irvine wrote:
> insert into phonenumbers values (425, 888, 0773);
>
> dncl=# select * from phonenumbers;
> areacode | prefix | suffix
> ----------+--------+--------
> 425 | 888 | 773
>
> Any ideas? Do I need to change the format of the fields again?
Put quotes around the values you're inserting, like this:
INSERT INTO phonenumbers VALUES ('425', '888', '0773');
HTH,
Adrian