Re: Display listings - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Display listings
Date
Msg-id web-1814729@davinci.ethosmedia.com
Whole thread Raw
In response to Display listings  (Setyo Nugroho <snugroho@gmx.net>)
List 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




pgsql-novice by date:

Previous
From: "Carson Wilcox"
Date:
Subject: libssl
Next
From: "cristi"
Date:
Subject: Re: Display listings