Thread: Outputting the Tables of a database

Outputting the Tables of a database

From
"Brian C. Doyle"
Date:
Hello all,

I am trying to out put the tables of a database. I have

psql -d mydb -c "\d"

This works but I am looking at turning on the html out put which it will 
not do.  If I am able to get just the table titles that would be most ideal.



Re: Outputting the Tables of a database

From
"Poul L. Christiansen"
Date:
You could possibly use grep and awk to filter the output.

See "man grep" and "man awk" for details.

"Brian C. Doyle" wrote:

> Hello all,
>
> I am trying to out put the tables of a database. I have
>
> psql -d mydb -c "\d"
>
> This works but I am looking at turning on the html out put which it will
> not do.  If I am able to get just the table titles that would be most ideal.