Re: phone number list - Mailing list pgsql-novice

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