Re: copy a database

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)