Re: lock entire database - Mailing list pgsql-novice

From Ron St-Pierre
Subject Re: lock entire database
Date
Msg-id 4113A48C.1040406@syscor.com
Whole thread Raw
In response to lock entire database  (Benjamin <benjamin@netyantra.com>)
Responses Re: lock entire database
List pgsql-novice
Benjamin wrote:

>
> In PGSQL, is it possible to lock the entire database??!!

Not that I know of, but why would you want to anyway?

>
> 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?

Check out the docs at
http://www.postgresql.org/docs/7.4/static/app-psql.html to see the psql
commands. With the \d you can see just the tables, views, etc (eg \dt).
Ron



pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: take endless time to MAKE on RH Linux 9
Next
From: reina_ga@hotmail.com (Tony Reina)
Date:
Subject: Re: inserting multiple rows