Re: [GENERAL] getting list of tables from command line

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               
http://archives.postgresql.org/