Re: lock entire database

#1

Benjamin wrote:

Quote:

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

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

Quote:

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: lock entire database

comp.databases.postgresql.novice comp.databases.postgresql.novice

Re: lock entire database - 08-06-2004 , 10:32 AM