On 6/29/05, Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> wrote:
>
> How could I truncate, delete all content of all tables in one step ?
You could use a query to generate the statements in psql:
\t
\o trunc_all.out
SELECT 'TRUNCATE ' || table_name || ';'
FROM information_schema.tables
WHERE table_schema='my_schema_name'
AND table_type='BASE TABLE';
\t
\o