2007/10/31, Craig White <craigwhite@xxxxxxxxxxx>:> 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.tableswhere table_schema='public'" ` -- Filip Rembiałkowski ---------------------------(end of broadcast)---------------------------TIP 4: Have you searched our list archives? http://archives.postgresql.org/