Re: Some Simple Questions

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Williams, Quinton L" <QWilliams(at)Central(dot)UH(dot)edu>
Cc: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Some Simple Questions
Date: 2003-09-29 17:19:14
Message-ID: 20030929171914.GB10856@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Sep 26, 2003 at 18:12:04 -0500,
"Williams, Quinton L" <QWilliams(at)Central(dot)UH(dot)edu> wrote:
> 1. How do you list the definitions of the tables you have created in a
> database?
> 2. How do you list the users in a database?

Using psql, you can use \d to list tables and \du to list users. \? can
be used to see a list of \ commands. If you want to see the SQL used by
these commands, you can run psql with the -E option.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-09-29 17:34:22 Re: Computed columns and functions?
Previous Message Bruno LEVEQUE 2003-09-29 17:00:44 Re: Some Simple Questions