Generating serial number column

Hi Everybody ,<br /><br />Is there a way in postgresql by which I can generate serial number column for the<br
/>resultset.I wanted the resulset to look like below<br /><br /><br />sno             Name<br />-------------------<br
/>1               JOE<br />2                JOHN<br />3                MARY<br />4                LISA<br
/>5               ANN<br />6                BILL<br />7                JACK<br />8 &nb sp;              WILL<br
/>9               GEORGE<br />10              NANCY<br />11               JANE<br /> .                    .<br
/> .                   .<br /> .                    .<br /><br />My query is basically select * name from tblcontact. I
wantedto generate<br />the column "sno" which basically numbers each row returned. Any help is<br />appreciated.<br
/>Regards,<br/>Tarun<br /><p><br /><hr size="1" />Do you Yahoo!?<br /><a
href="http://rd.yahoo.com/O=1/I=brandr/vday03/text/flow/*http://shopping.yahoo.com
/shop?d=browse&id=20146735">Yahoo! Shopping</a> - Send Flowers for Valentine's Day