RESOLVED : Re: sql script questions

Okay:

i figured out my problem through a shell script.

yeah, it probably seems real easy, i just don't
have many people to bounce ideas off of.

anyway - what i wanted was to to into postgres,
get a list of tables and their attributes and
send them to individual files for documentation
at a later date.

this is my silly script:

[script]

#!/bin/ksh -x

# gonna try to create a script
# that gets a list of tables and
# then for each table, get their attributes

datestr=`date +%d%m%y`
workdir=/home/shaunn/temp
tmp1=$workdir/temp1

#remove temp files
if [ -f $tmp1 ];
then
rm -f $tmp1
else
exit 1
fi

#get list of tables and put into tmp1 file

/usr/bin/psql -d bcn -U web -tc "\d" | awk '{print $1}' > $tmp1

for i in `cat $tmp1`
do
/usr/bin/psql -d bcn -U web -tc "\d $i" > $workdir/$i.out
done

[/script]

the lines featuring '/usr/bin/psql' are the ones i
was having an issue with initially. couldn't figure out
the syntax and didn't know, frankly, that i could use
those options.

the second to last line featuring '$workdir/$i.out' is
what gave me multiple files with their own table
attributes instead of outfile.$$ (which only gave
me ONE file with ONE PID attached to it. i was
under the illusion that each time the script read
through the loop, a new file would be created and
affix a new PID. *shrug* don't know why that didn't
happen')

anyhow - that's my story and i'm sticking to it.

-X

shaunnx(at)my-deja(dot)com (X) wrote in message news:<6375fd1b(dot)0110231150(dot)3a7b0556(at)posting(dot)google(dot)com>...
> Howdy:
>
> Please redirect me if this is the wrong group. My question
> is pretty much SQL related for Postres.
>
> I want to write a script (either shell or SQL) to:
>
> 1) get a list of tables
> 2) get the list of attributes, type and modifyer
> of each table.
>
> It is something in the way of:
>
> for i in `\d`
> do
> \d $i
> done
>
> As far as I can tell, '\d' describes a table, view or what
> have you. '\d' alone gives me a list of tables and views I
> have in my database.
>
> Any examples out there that does this?
>
> TIA!
>
> -X