Re: Line Numbering in SELRCT Output - Mailing list pgsql-sql

CREATE SEQUENCE seq1;

SELECT nextval('seq1'), amname FROM pg_am;

DROP SEQUENCE seq1;

"Hubert Palme" <hubert.palme@web.de> wrote in message
news:a6e70l$2o5p$1@jupiter.hub.org...
> Hi,
>
> how can I get line numbers in the output of a select statement, e.g.
>
> No.  | Name             | ...
> -----+------------------+-------
>    1 | Meyer            | ...
>    2 | Miller           | ...
>    3 | Mueller          | ...
>    4 | Smith            | ...
>
> Thanks in advance,
> --
> Hubert Palme                           Am Walde 1
>                                  42119 Wuppertal
> <hubert.palme@web.de>