Re: copy a database - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: copy a database
Date
Msg-id 20040825162606.GC18252@dcc.uchile.cl
Whole thread Raw
In response to Re: copy a database  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
On Wed, Aug 25, 2004 at 12:09:58PM -0400, Alvaro Herrera wrote:

> No, pg_user is a view on pg_shadow ...
>
> SELECT pg_shadow.usename, pg_shadow.usesysid, pg_shadow.usecreatedb,
> pg_shadow.usesuper, pg_shadow.usecatupd, '********'::text AS passwd,
> pg_shadow.valuntil, pg_shadow.useconfig FROM pg_shadow;

Sorry, this is obviously missing the

CREATE VIEW pg_user AS

part.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"The important things in the world are problems with society that we don't
understand at all. The machines will become more complicated but they won't
be more complicated than the societies that run them."    (Freeman Dyson)


pgsql-general by date:

Previous
From: DeJuan Jackson
Date:
Subject: The Slony General List
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions