Re: Simple list tables question - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Simple list tables question
Date
Msg-id 20040321174823.GA22480@wolff.to
Whole thread Raw
In response to Simple list tables question  (Mihai Tanasescu <Mihai.Tanasescu@skyraven.pcnet.ro>)
List pgsql-general
On Sun, Mar 21, 2004 at 14:21:51 +0200,
  Mihai Tanasescu <Mihai.Tanasescu@skyraven.pcnet.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.

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Simple list tables question
Next
From: Ken Godee
Date:
Subject: "select for update" confusion