Skip site navigation (1) Skip section navigation (2)

Re: copy a database

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: dsuela(at)xsto(dot)info, Christopher Browne <cbbrowne(at)acm(dot)org>,pgsql-general(at)postgresql(dot)org
Subject: Re: copy a database
Date: 2004-08-25 16:26:07
Message-ID: 20040825162606.GC18252@dcc.uchile.cl (view raw or flat)
Thread:
Lists: 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)


In response to

pgsql-general by date

Next:From: Thomas HallgrenDate: 2004-08-25 16:39:44
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions
Previous:From: Alvaro HerreraDate: 2004-08-25 16:24:46
Subject: Re: any solution for full text search in Postgres for partial words

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group