Postgres Pro
Downloads
Home   >   mailing lists

Re: getting list of tables from command line - Mailing list pgsql-general

From Reece Hart
Subject Re: getting list of tables from command line
Date
Msg-id 1193846688.6897.5.camel@snafu
Whole thread Raw
In response to getting list of tables from command line  (Craig White <craigwhite@azapple.com>)
List pgsql-general
Tree view 
On Wed, 2007-10-31 at 08:01 -0700, Craig White wrote:
> I wanted a way to
> query a database and get a text file with just the table names and
> cannot figure out a way to do that.

This should do the trick:

$ psql -Atc "select table_schema||'.'||table_name from
information_schema.tables"

-Reece

--
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Join between tables of two or more databases
Next
From: Douglas McNaught
Date:
Subject: Re: Securing stored procedures and triggers