fixes snippet for pg