[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Similar app for Disk Catalog?



On 10:31 Sun 07 Sep?, elijah wrote:
> On 15:42 Sat 06 Sep?, Oliver Elphick wrote:
> > Something like this (using PostgreSQL)?
> > 
> > $ psql -d mydatabase -c "CREATE TABLE diskcat (directory text not null,
> > file text not null, primary key (directory, file))"
> > 
> > $ for f in `find mydirectory -type f`
> >   do
> > 	echo -e "`dirname $f`\t`basename $f`"
> >   done | psql -d mydatabase -c "COPY diskcat FROM STDIN"
> 
> An app would be ideal but I guess scripts would do, thanks I'll try to
> study that one :)
> 
> 
> Elijah



Reply to: