Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: getting list of tables from command line
- From: Reece Hart <reece(at)harts(dot)net>
- To: Craig White <craigwhite(at)azapple(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: getting list of tables from command line
- Date: Wed, 31 Oct 2007 09:04:48 -0700
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
- References:
- getting list of tables from command line
- From: Craig White
- getting list of tables from command line
- Prev by Date: Re: Join between tables of two or more databases
- Next by Date: Re: Securing stored procedures and triggers
- Previous by thread: getting list of tables from command line
- Next by thread: Re: getting list of tables from command line
- Indexes: