On 8/20/07, Livia Santos <[EMAIL PROTECTED]> wrote: > Hi. > > Is there any command that describe a table, such as desc table_name as in > Oracle?
Yes and no. The psql client has a series of \ commands that can describe pretty much anything in the db in a pretty print nature and a minimum of typing. The \ commands are NOT implemented in the backend, but in the psql client so you can't just hit the db with \d from a libpq connection to get a list of all tables / views / sequences. However, you can use psql -E to have psql show you al lthe queries it's throwing at the backend to get that pretty output, and then you can take what it's doing and either wrap it in a view for future use, or run it directly. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
