-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 >> greg=# select count(*) from pg_class where relkind='r' and relname ~ 'foo' >> count >> - --------- >> 1000000 > Try \dt :D Sure. Took 42 seconds, but it showed up just fine. :) List of relations Schema | Name | Type | Owner - --------+-----------+-------+------- public | foo1 | table | greg public | foo10 | table | greg public | foo100 | table | greg public | foo1000 | table | greg public | foo10000 | table | greg public | foo100000 | table | greg public | foo100001 | table | greg public | foo100002 | table | greg public | foo100003 | table | greg etc... - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 200603100913 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFEEYpuvJuQZxSWSsgRAnXFAKCQD31fIXDvN/2lLl9Unaw0zvAdcgCgkHxh WsrUkThL+xYz6bdzvZ5jqA4= =4TZu -----END PGP SIGNATURE-----
pgsql-advocacy by date:
Соглашаюсь с условиями обработки персональных данных