dumping the schema

From: "raptor(at)tvskat(dot)net" <raptor(at)tvskat(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: dumping the schema
Date: 2004-07-23 08:49:14
Message-ID: 20040723114914.3e18c161@bugs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How to DUMP the Database schema, (so later can get it back i.e recreate everything).
I need only the schema (tables, users, groups etc..) now (not the data, is it any different if i want the data too).

the dump should be in order so that i can just execute it...

One more thing I created db and tables with default config (with pgadmin3) i.e. owner postgres,
Now I want to switch all to other user I just created, can I do it "at once" or I
have to go and edit permission of every table...
Can I remove any access to the DB for "postgres" and "public" and leave such access to
my new user OR they should stay for some db-functionality..

tia

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2004-07-23 09:34:49 Re: dumping the schema
Previous Message Holger Klawitter 2004-07-23 06:52:12 Re: any benefit to preparing a sql function?