Hello the most similar tool in pg is "VACUUM FULL" statemet;
Regards Pavel Stehule 2012/2/29 Rehan Saleem <pk_re...@yahoo.com>: > hi , > how can i shrink database in postgresql here is a MS-SQL store procedure > which shrinks the database. how same task can be achieved in postgresql. > > ALTER PROCEDURE [dbo].[sp_CleanUpDB] > AS > declare @db nvarchar(50) > select @db = db_name() > DBCC SHRINKDATABASE (@db, 10) > > thanks > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
