lock entire database

From: Benjamin <benjamin(at)netyantra(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: lock entire database
Date: 2004-08-05 05:39:48
Message-ID: 4111C824.7040204@netyantra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


In PGSQL, is it possible to lock the entire database??!!
This could be done with locking with individual table locking, but any
way to lock the entire db??
If this is the only way, how do i get the listing of the tables? thru
'\d' ?? and then 'cut' or 'sed ' on it to get the individual table names?

--

Benjamin Jacob.

Disclaimer :
------------------------------------------------------------------------------
If you are not the intended recipient of this transmission to whom it is
addressed, or have received this transmission in error, you are hereby
notified that any dissemination, distribution or copying of this transmission
is strictly prohibited. Please notify us immediately and delete this e-mail
from your system. The sender does not accept liability for any errors or
omissions in the contents of this message which arise as a result of e-mail
transmission, which cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, arrive at wrong address or contain viruses. If verification
is required please request a hard-copy version. This e-mail contains only the
personal opinions of the sender and does not represent an official
communication from NetYantra of any manner.
------------------------------------------------------------------------------

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Fromme 2004-08-05 08:53:36 Re: Column name truncation
Previous Message Tom Lane 2004-08-05 02:39:32 Re: UNICODE and regex character classes