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

From Filip Rembiałkowski
Subject Re: getting list of tables from command line
Date
Msg-id 92869e660710311025x12c171bbg5f3cd5acf006f023@mail.gmail.com
Whole thread Raw
In response to getting list of tables from command line  (Craig White <craigwhite@azapple.com>)
List pgsql-general
2007/10/31, Craig White <craigwhite@azapple.com>:
> I wrote a little script to individually back up table schemas, table
> data and then vacuum the table and it works nicely but 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.


for table in ` psql -qAtc "select table_name from information_schema.tables
where table_schema='public'" `



--
Filip Rembiałkowski

pgsql-general by date:

Previous
From: João Paulo Zavanela
Date:
Subject: Re: Install plJava
Next
From: "T.J. Adami"
Date:
Subject: Server's Locale