Re: Simple list tables question

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Mihai Tanasescu <Mihai(dot)Tanasescu(at)skyraven(dot)pcnet(dot)ro>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Simple list tables question
Date: 2004-03-21 17:48:23
Message-ID: 20040321174823.GA22480@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Mar 21, 2004 at 14:21:51 +0200,
Mihai Tanasescu <Mihai(dot)Tanasescu(at)skyraven(dot)pcnet(dot)ro> wrote:
>
> Isn't the postgres user the same as the root user from mysql ?
> I mean there must be a user that has enough rights by default to list
> tables in any databases ( I don't like granting myself right for every
> database someone creates)

Not necessarily. The username of the user that does the initdb is the
postgres superuser by default. You can use the -U option if you
want the username to be something else.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ken Godee 2004-03-22 00:10:39 "select for update" confusion
Previous Message Martijn van Oosterhout 2004-03-21 12:25:27 Re: Simple list tables question