On Wed, Oct 31, 2007 at 08:01:41AM -0700, Craig White wrote: > my script looks like this... > (all I want is to get a list of the tables into a text file pg_tables) everybody else showed some ways, but i'll ask a question: i hope you're not treating it as a backup? bacause when you do it that way (on table-by-table basic) the "backup" is practically useless as it doesn't have internal consistency. if you want to make backup, perhaps you can tell us exactly what you want to do, and why standard pg_dump is not enough. if you're fully aware of the issue i pointed - sorry, i'm just trying to make sure you'll not shoot yourself in a foot. depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
