Adding Postgres Objects to Template1

Question

I'm trying to add some demo data to template1 that will be automatically added to all future User Trial Databases.

My question is: How do you run SQL statements from pgAdmin III on template1?

My understanding of templates may be off - i've read this page (pretty much all I was able to find on templates) http://dave.webdev.pgadmin.org/docs/1.6/pg/manage-ag-templatedbs.html

My postgres version is 8.4

A template is a database, you just connect to it and run the create statements as in any other database. — Daniel Vérité
– Daniel Vérité, Commented Jul 31, 2014 at 12:54

codine · Accepted Answer · 2014-07-31 23:29:33Z

3

I figured this out. In pgAdmin templates are hidden by default - you have to change a setting to make them visible.

Setting in pgAdmin III v>1.16 File -> Options -> UI Miscellaneous -> check 'Show System Objects in the treeview'

Settings in pgAdmin III v<1.16 File -> Options -> Display -> check 'Show System Objets in the treeview' (at the top)

answered Jul 31, 2014 at 23:29

codine

771 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1