|
11 | 11 | # |
12 | 12 | # |
13 | 13 | # IDENTIFICATION |
14 | | -# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/clusterdb,v 1.3 2002/09/12 00:18:14 momjian Exp $ |
| 14 | +# $Header: /cvsroot/pgsql/src/bin/scripts/Attic/clusterdb,v 1.4 2002/09/27 17:51:10 momjian Exp $ |
15 | 15 | # |
16 | 16 | #------------------------------------------------------------------------- |
17 | 17 |
|
|
153 | 153 | fordbin$dbname |
154 | 154 | do |
155 | 155 | ["$alldb" ]&&echo"Clustering$db" |
156 | | -query="SELECT nspname, pg_class.relname, pg_class_2.relname FROM pg_class, pg_class AS pg_class_2 JOIN pg_namespace ON (pg_namespace.oid=relnamespace), pg_index WHERE pg_class.oid=pg_index.indrelid AND pg_class_2.oid=pg_index.indexrelid AND pg_index.indisclustered" |
| 156 | +query="SELECT nspname, pg_class.relname, pg_class_2.relname FROM pg_class, pg_class AS pg_class_2 JOIN pg_namespace ON (pg_namespace.oid=relnamespace), pg_index WHERE pg_class.oid=pg_index.indrelid AND pg_class_2.oid=pg_index.indexrelid AND pg_index.indisclustered AND pg_class.relowner=(SELECT usesysid FROM pg_user WHERE usename=current_user)" |
157 | 157 | if [-z"$table" ];then |
158 | 158 | tables=`${PATHNAME}psql$db$PSQLOPT -F: -P format=unaligned -t -c"$query"` |
159 | 159 | else |
|