Re: Display listings

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Setyo Nugroho <snugroho(at)gmx(dot)net>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Display listings
Date: 2002-11-06 17:55:31
Message-ID: web-1814729@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Setyo,

> How is it to display the listings/ detailed descriptions of a
> function
> or a table created using plpgsql or using database client such as
> psql?

Check out the \d commands through PSQL:

\dt gives you a listing of all tables
\df gives you a listing of all functions
\d table-name gives you a schema of the table
\d function-name gives you a list of parameters
etc.

Typing "\?" on the PSQL command line will show you more options.

-Josh

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message cristi 2002-11-07 06:04:21 Re: Display listings
Previous Message Chris Thompson 2002-11-06 17:48:06 Re: libssl