Hi, I mostly use PG from command line, I wish to get a command that
enable me to see already defined functions, procedures, triggers etc etc.
I looked for such a command on documentation but wasn't able to find
anything, does someone know how to get it? Furthermore, does someone
knows a web page dealing about psql for power users?
Thanks in advance and sorry for bad English from Italian guy

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> writes:

In an interactive 'psql' session, use the '\?' shortcut to see a list
of other shortcut commands. (I'm calling them "shortcuts" because
behind the scenes most of them merely perform a specific query on the
database.)

The 'Informational' section is especially relevant here; most of them
are "list" commands.

Any of these can be executed from a command-line by simply providing
the command on standard input to 'psql'. For example, to list
functions in the 'public' schema of database 'dbname':

$ echo '\df public.*' | psql dbname username

--
\ "I like to fill my bathtub up with water, then turn the shower |
`\ on and pretend I'm in a submarine that's been hit." -- Steven |
_o__) Wright |
Ben Finney

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> writes:

In an interactive 'psql' session, use the '\?' shortcut to see a list
of other shortcut commands. (I'm calling them "shortcuts" because
behind the scenes most of them merely perform a specific query on the
database.)

The 'Informational' section is especially relevant here; most of them
are "list" commands.

Any of these can be executed from a command-line by simply providing
the command on standard input to 'psql'. For example, to list
functions in the 'public' schema of database 'dbname':

$ echo '\df public.*' | psql dbname username

--
\ "I like to fill my bathtub up with water, then turn the shower |
`\ on and pretend I'm in a submarine that's been hit." -- Steven |
_o__) Wright |
Ben Finney

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> writes:

In an interactive 'psql' session, use the '\?' shortcut to see a list
of other shortcut commands. (I'm calling them "shortcuts" because
behind the scenes most of them merely perform a specific query on the
database.)

The 'Informational' section is especially relevant here; most of them
are "list" commands.

Any of these can be executed from a command-line by simply providing
the command on standard input to 'psql'. For example, to list
functions in the 'public' schema of database 'dbname':

$ echo '\df public.*' | psql dbname username

--
\ "I like to fill my bathtub up with water, then turn the shower |
`\ on and pretend I'm in a submarine that's been hit." -- Steven |
_o__) Wright |
Ben Finney

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> writes:

In an interactive 'psql' session, use the '\?' shortcut to see a list
of other shortcut commands. (I'm calling them "shortcuts" because
behind the scenes most of them merely perform a specific query on the
database.)

The 'Informational' section is especially relevant here; most of them
are "list" commands.

Any of these can be executed from a command-line by simply providing
the command on standard input to 'psql'. For example, to list
functions in the 'public' schema of database 'dbname':

$ echo '\df public.*' | psql dbname username

--
\ "I like to fill my bathtub up with water, then turn the shower |
`\ on and pretend I'm in a submarine that's been hit." -- Steven |
_o__) Wright |
Ben Finney

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> writes:

In an interactive 'psql' session, use the '\?' shortcut to see a list
of other shortcut commands. (I'm calling them "shortcuts" because
behind the scenes most of them merely perform a specific query on the
database.)

The 'Informational' section is especially relevant here; most of them
are "list" commands.

Any of these can be executed from a command-line by simply providing
the command on standard input to 'psql'. For example, to list
functions in the 'public' schema of database 'dbname':

$ echo '\df public.*' | psql dbname username

--
\ "I like to fill my bathtub up with water, then turn the shower |
`\ on and pretend I'm in a submarine that's been hit." -- Steven |
_o__) Wright |
Ben Finney

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> writes:

In an interactive 'psql' session, use the '\?' shortcut to see a list
of other shortcut commands. (I'm calling them "shortcuts" because
behind the scenes most of them merely perform a specific query on the
database.)

The 'Informational' section is especially relevant here; most of them
are "list" commands.

Any of these can be executed from a command-line by simply providing
the command on standard input to 'psql'. For example, to list
functions in the 'public' schema of database 'dbname':

$ echo '\df public.*' | psql dbname username

--
\ "I like to fill my bathtub up with water, then turn the shower |
`\ on and pretend I'm in a submarine that's been hit." -- Steven |
_o__) Wright |
Ben Finney

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> writes:

In an interactive 'psql' session, use the '\?' shortcut to see a list
of other shortcut commands. (I'm calling them "shortcuts" because
behind the scenes most of them merely perform a specific query on the
database.)

The 'Informational' section is especially relevant here; most of them
are "list" commands.

Any of these can be executed from a command-line by simply providing
the command on standard input to 'psql'. For example, to list
functions in the 'public' schema of database 'dbname':

$ echo '\df public.*' | psql dbname username

--
\ "I like to fill my bathtub up with water, then turn the shower |
`\ on and pretend I'm in a submarine that's been hit." -- Steven |
_o__) Wright |
Ben Finney

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> writes:

In an interactive 'psql' session, use the '\?' shortcut to see a list
of other shortcut commands. (I'm calling them "shortcuts" because
behind the scenes most of them merely perform a specific query on the
database.)

The 'Informational' section is especially relevant here; most of them
are "list" commands.

Any of these can be executed from a command-line by simply providing
the command on standard input to 'psql'. For example, to list
functions in the 'public' schema of database 'dbname':

$ echo '\df public.*' | psql dbname username

--
\ "I like to fill my bathtub up with water, then turn the shower |
`\ on and pretend I'm in a submarine that's been hit." -- Steven |
_o__) Wright |
Ben Finney

Coniglio Sgabbiato <nobody (AT) nowhere (DOT) it> wrote:
http://www.postgresql.org/docs/curre.../app-psql.html

or alternatively the man page.

So far it has answered all I needed to know about psql, and I would
call myself a power user.

Yours,
Laurenz Albe