Received: from cask.force9.net (cask.force9.net [195.166.128.29]) by hub.org (8.9.3/8.9.3) with SMTP id NAA12252 for ; Sat, 5 Jun 1999 13:57:17 -0400 (EDT) (envelope-from stevew@bigeric.force9.co.uk) Received: (qmail 18284 invoked from network); 5 Jun 1999 17:57:23 -0000 Received: from relay3.force9.net (HELO relay2.force9.net) (195.166.128.25) by cask.force9.net with SMTP; 5 Jun 1999 17:57:23 -0000 Received: (qmail 18926 invoked from network); 5 Jun 1999 17:51:21 -0000 Received: from 351.hiper03.shef.dialup.force9.net (HELO erica) (195.166.147.95) by relay3.force9.net with SMTP; 5 Jun 1999 17:51:21 -0000 Received: by erica with MailBeamer v3.20 (WinNT 4.x Service) ; Sat, 5 Jun 1999 19:00:18 +0100 From: stevew To: "'postgres post'" Subject: internal tables Date: Sat, 5 Jun 1999 19:00:00 +0100 X-Mailer: MailBeamer v3.20 (WinNT 4.x Service) Message-ID: <171226818.1144365.84@erica> X-Priority: 3 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi there, I usually use Oracle at work but I am working with Postgres at home on Linux. In Oracle there are a number of system tables and views which tell you about the database. Are there the same things in Postgres and if so where are they documented. What I am looking for is info on my current connection/session to postgres.... session_id host etc... Thanks for any help. Regards, Steve W