| 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: | Whole Thread | Raw Message | 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
| 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? |