CREATE SEQUENCE seq1;
SELECT nextval('seq1'), amname FROM pg_am;
DROP SEQUENCE seq1;
"Hubert Palme" <hubert(dot)palme(at)web(dot)de> wrote in message
news:a6e70l$2o5p$1(at)jupiter(dot)hub(dot)org(dot)(dot)(dot)
> 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(dot)palme(at)web(dot)de>