Bruce Momjian wrote:
> David Gardner wrote:
> > Earlier today I was tempted to start storing usesysid's as foreign keys
> > in one of my tables by doing:
> > SELECT usesysid FROM pg_user WHERE pg_user.usename= user;
> >
> > My proposed FAQ entry is based on this mailing list post which convinced
David Gardner wrote:
> Earlier today I was tempted to start storing usesysid's as foreign keys
> in one of my tables by doing:
> SELECT usesysid FROM pg_user WHERE pg_user.usename= user;
>
> My proposed FAQ entry is based on this mailing list post which convinced
> me not to:
> http://archives.p
On Thu, 2007-28-06 at 13:31 +0200, Susanne Ebrecht wrote:
> Than I just tried: alter table pgview rename to bettername;
>
> that works, but there is no hint at the documentation, that you can
> rename a view via alter table.
>From the ALTER TABLE reference page: "The RENAME forms change the nam
Susanne Ebrecht <[EMAIL PROTECTED]> writes:
> that works, but there is no hint at the documentation, that you can
> rename a view via alter table.
It is mentioned someplace (don't remember where). Where would you have
expected to find it?
regards, tom lane
-
Hi all,
I got the question: how can I rename a view?
At the first moment, I have had no idea ... and I asked the German guys
at IRC.
They have had no idea too.
Than I just tried: alter table pgview rename to bettername;
that works, but there is no hint at the documentation, that you can
ren
