[SQL] Outputting the Tables of a database

2000-06-14 Thread Brian C. Doyle
Hello all, What would the query line be to mimic mydb=>\d tablename ? I have been able to run a query to mimic #psql -l and to mimic mydb=>\d thanks for the help Brian

Re: [SQL] Outputting the Tables of a database

2000-06-14 Thread Poul L. Christiansen
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 w

[SQL] Outputting the Tables of a database

2000-06-14 Thread Brian C. Doyle
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.