Re: getting list of tables from command line

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)