Archive for the 'Postgresql' Category

Jun27

PostgreSQL: Quickly empty tables

If you have ever run into trouble while removing contents from large tables (because of foreign keys, relations, their huge size, or whatsoever), this is the ultimate solution: TRUNCATE.

truncate table audit cascade;

In my case, this resulted in truncation of all tables (since every table has a reference to the audit table). If you wish […]

Continue Reading »

Filed in: Postgresql Technical



About

Impessa LTD provides IT solutions tailored to business needs. Impessa specializes in providing web and software development services including solution integration and offshore IT outsourcing across the globe.