[SQL] Desc Commnad in pgsql?

Hello All, I like to know how can I achieve the same functionality that is give by desc commnad in mysql or oracle. Also specify me the book related to pgsql as a beginner. Presently my task is going to be communication of ruby with pgsql Thanks in advanced. Vikas

[SQL] psql: FATAL: Ident authentication failed for user "postgres"

Hi, I have installed postgresql-serve using yum hba.conf group and owner were postgres then i changed it to root. when i type psql -U postgres command ( as root user) I get: psql: FATAL: Ident authentication failed for user "postgres" My file permission are: drwx-- 5 postgres postgres 40