Postgres Pro
Downloads
Home   >   mailing lists

Re: copying pg_user? - Mailing list pgsql-novice

From Tom Lane
Subject Re: copying pg_user?
Date
Msg-id 28300.965166312@sss.pgh.pa.us
Whole thread Raw
In response to copying pg_user?  (James Hall <James.Hall@RadioShack.com>)
List pgsql-novice
Tree view 
James Hall <James.Hall@RadioShack.com> writes:
> My question is what is the easiest/best/safest way to copy the pg_user file
> from db to another?

pg_user is a view.  You can copy pg_shadow if you are so inclined.
See the pg_dumpall script, which does exactly that before dumping
the database(s) proper.

            regards, tom lane

pgsql-novice by date:

Previous
From: James Hall
Date:
Subject: copying pg_user?
Next
From: "Chau, Artemis"
Date:
Subject: count(distinct col)