Postgres Pro
Downloads
Home   >   mailing lists

Re: Some Simple Questions - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Some Simple Questions
Date
Msg-id 20030929171914.GB10856@wolff.to
Whole thread Raw
In response to Some Simple Questions  ("Williams, Quinton L" <QWilliams@Central.UH.edu>)
Responses Install question  ("Mickey" <mickey@mcnjeni.com>)
List pgsql-novice
Tree view 
On Fri, Sep 26, 2003 at 18:12:04 -0500,
  "Williams, Quinton L" <QWilliams@Central.UH.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.

pgsql-novice by date:

Previous
From: Bruno LEVEQUE
Date:
Subject: Re: SQL Syntax problem
Next
From: Josh Berkus
Date:
Subject: Re: Computed columns and functions?