Postgres Pro
Downloads
Home   >   mailing lists

template1 - recreate - Mailing list pgsql-sql

From Rudi Starcevic
Subject template1 - recreate
Date
Msg-id 3D0D7F16.9000408@oasis.net.au
Whole thread Raw
Responses Re: template1 - recreate  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Tree view 
Hello friends,

I've been searching without joy so far so I thought I'd ask.
I know I can re-create 'template1'.
I need to do this as I've messed up the current template1 - Oops !

Fortunately Postgresql make's backups so easy no data is lost or corrupted.

What's the simple command to create 'template1' from 'template0' ?

Thanks heaps in advance.

Best Regards
Rudi Starcevic.

pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: inheritance problems
Next
From: Christoph Haller
Date:
Subject: join question - requesting for a simple C program where it can INSERT data into database as reference