Postgres Pro
Downloads
Home   >   mailing lists

Thread: Lock full database

Lock full database

From
"guard"
Date:
dear all

I want lock full tables,how to write SQL command?
thanks



--

Re: Lock full database

From
Haller Christoph
Date:
> 
> I want lock full tables,how to write SQL command?
> thanks
> 
BEGIN ; 
LOCK TABLE <tablename> ; 
/* done, locked until "commit;" */ 

Refer to the SQL-LOCK-command for further 
information. 
Regards, Christoph