Calls to find Users and databases open...

Thomas LeBlanc

What are the SQL commands to find who is logged on a server, what database
he/she has open, etc?

Where is this information in the help file or documentation?

Thanks,
Thomas

_______________ _______________ _______________ _______________ _____
FREE pop-up blocking with the new MSN Toolbar – get it now!
http://toolbar.msn.com/go/onm00200415ave/direct/01/
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #1

Subscribe Reply

1371

Martin Marques

El Vie 30 Abr 2004 11:16, Thomas LeBlanc escribió:

What are the SQL commands to find who is logged on a server, what database
he/she has open, etc?

Where is this information in the help file or documentation?

select * from pg_stat_activit y;

--
11:47:01 up 1 day, 17:09, 3 users, load average: 0.21, 0.65, 0.89
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #2

Martin Marques

El Vie 30 Abr 2004 11:16, Thomas LeBlanc escribió:

What are the SQL commands to find who is logged on a server, what database
he/she has open, etc?

Where is this information in the help file or documentation?

Nov 23 '05 #3

Similar topics

3720

[perl-python] find & replace strings for all files in a dir

by: Xah Lee | last post by:

suppose you want to do find & replace of string of all files in a directory. here's the code: ©# -*- coding: utf-8 -*- ©# Python © ©import os,sys © ©mydir= '/Users/t/web'

Python

1225

Problem with mysql api calls.

by: jwl | last post by:

I'm having a problem with a bit of code that I have "adopted". It was partially complete when I took it over. The function of the code is to read a log file, locate files described in that log file and fill in a few tables in a couple of MySql databases. The program is using a number of std objects, hashmaps, linklists, vectors etc. It makes direct calls to the MySql api. The version of MySql is 3.23.58. Redhat 9, g++ (GCC) 3.2.2...

C / C++

1566

Multiple Users

by: Berj | last post by:

i have a novice question. is Access multi-user? can multiple users access the same database?

Microsoft Access / VBA

5161

Audit Users/Login databases/tracking

by: MUHAMAMD SALIM SHAHZAD | last post by:

dear respected gurus, I would like to share ideas...as i learned from you and wish to tell that i had developed the system where i can audit each and every users and their actions(like add/edit/save/cancel/unco) =======================start of modules======================================= Option Compare Database Option Explicit

Microsoft Access / VBA

539

Asp.net runtime error - multiple users with Access Db

by: mark | last post by:

I have an asp.net ecommerce web application on a remote web server. I'm using an Access database on the back end. I've notice a few strange things. When I mimic an multiple user environment by surfin it in multiple browsers simultaneously the site generates a generic runtime error after awhile. I'm thinking this has something to do with my access database and multiple connections. I'm using forms authentication with a login page. Is...

ASP.NET

250

Calls to find Users and databases open...

by: Thomas LeBlanc | last post by:

PostgreSQL Database

1851

How do I find the remote DB's that link to my tables?

by: Bruce Lawrence | last post by:

We use Access 97. We are in the process of migrating to 2003 along with SQL in most cases. We have a production database that contains a pretty important table and we would like to know which other databases on our network link to this table. The reason is because we plan to add/remove certain fields in this table when we put it in SQL but we would like to know ahead of time which databases will be affected by this. I seem to...

Microsoft Access / VBA

1028

How To Prevent Multible Users Of Application From Clobbering Each Other

by: Christopher Lusardi | last post by:

How can I prevent multible people, who use my program at the exact same time, from overwritting textfiles? E.G.: Two users start the same program and one deletes something but the other saves his data and undoes the delete that was done! Also, what about databases being overwritten at the same time. How can I prevent users from interfering with each other? Thank you, Christopher Lusardi

Visual Basic .NET

2358

PEP thought experiment: Unix style exec for function/method calls

by: Michael | last post by:

Hi, I'm having difficulty finding any previous discussion on this -- I keep finding people either having problems calling os.exec(lepev), or with using python's exec statement. Neither of which I mean here. Just for a moment, let's just take one definition for one of the

Python

8449

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8784

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8556

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8642

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6198

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5666

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4371

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2774

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1777

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General