Postgres Pro
Downloads
Home   >   mailing lists

Re: enumerating rows - Mailing list pgsql-sql

From Luis C. Ferreira
Subject Re: enumerating rows
Date
Msg-id 9b3g5k$1iq6$1@news.tht.net
Whole thread Raw
In response to enumerating rows  (Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu>)
List pgsql-sql
Tree view 
Try this....

CREATE SEQUENCE just_a_seq;
Select nextval('just_a_seq') as row_no, * from pg_tables ;
drop SEQUENCE just_a_seq;

>
> row_no | column1 | column2 | ...
> -------+---------+---------+ ...
>      1 | datum11 | datum12 | ...
>      2 | datum21 | datum22 | ...
>    ... |     ... |     ... | ...
>
> I didn't find anything in the docs.
>
> TIA, Zoltan
>

pgsql-sql by date:

Previous
From: Hans-Jürgen Schönig
Date:
Subject: Savepoints
Next
From: Sharmad Naik
Date:
Subject: SELECT query