Re: standard IDENTITY support (Was: Re: [ADMIN] SERIAL type not autoincremented)

2004-07-05 Thread Bruno Wolff III
On Mon, Jul 05, 2004 at 01:42:35 +0200, Markus Bertheau <[EMAIL PROTECTED]> wrote: > ?? ??, 02.07.2004, ?? 19:22, [EMAIL PROTECTED] ??: > > Hello > > i have: > > create table student( > > id SERIAL NOT NULL, > > name VARCHAR(35) NOT NULL, > > primary

Re: [ADMIN] How to list what queries are running in postgres?

2004-07-05 Thread Bruce Momjian
Tom Lane wrote: > Gaetano Mendola <[EMAIL PROTECTED]> writes: > > P.A.M. van Dam wrote: > >> I'm looking for a command or method to find out what queries are > >> currently being serviced by the database. > > > select * from pg_stat_activity; > > ... having first remembered to turn on stats_comm