Re: lock entire database

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