pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: Outputting the Tables of a database
3+ messages / 2 participants
[nested] [flat]

* Outputting the Tables of a database
@ 2000-06-14 16:46 Brian C. Doyle <bcdoyle@mindspring.com>
  2000-06-14 16:07 ` Re: Outputting the Tables of a database Poul L. Christiansen <plc@faroenet.fo>
  0 siblings, 1 reply; 3+ messages in thread

From: Brian C. Doyle @ 2000-06-14 16:46 UTC (permalink / raw)
  To: pgsql-sql

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.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Outputting the Tables of a database
  2000-06-14 16:46 Outputting the Tables of a database Brian C. Doyle <bcdoyle@mindspring.com>
@ 2000-06-14 16:07 ` Poul L. Christiansen <plc@faroenet.fo>
  0 siblings, 0 replies; 3+ messages in thread

From: Poul L. Christiansen @ 2000-06-14 16:07 UTC (permalink / raw)
  To: Brian C. Doyle <bcdoyle@mindspring.com>; +Cc: pgsql-sql

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.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Outputting the Tables of a database
@ 2000-06-14 19:47 Brian C. Doyle <bcdoyle@mindspring.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Brian C. Doyle @ 2000-06-14 19:47 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2000-06-14 19:47 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-14 16:46 Outputting the Tables of a database Brian C. Doyle <bcdoyle@mindspring.com>
2000-06-14 16:07 ` Poul L. Christiansen <plc@faroenet.fo>
2000-06-14 19:47 Outputting the Tables of a database Brian C. Doyle <bcdoyle@mindspring.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox