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