Re: programatically obtaining table layout

> Is there a way of getting the output of a \d tablename  from within a
> program (like describe in mysql)

If I understand your question correctly, you mean how do I do what this
does:

  psql -c "\d $tablename" $dbname $username

Try this:

  psql --help

Notice the -E option:

  -E              Display queries that internal commands generate

So:

  psql -c "\d $tablename" -E $dbname $username

Cheers,

// mark

-