pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPG SQL scripts
2+ messages / 2 participants
[nested] [flat]
* PG SQL scripts
@ 2005-04-21 15:25 Nigel Bishop <Nigel.Bishop@ioko.com>
0 siblings, 1 reply; 2+ messages in thread
From: Nigel Bishop @ 2005-04-21 15:25 UTC (permalink / raw)
To: pgsql-admin
Hi,
Does anyone know of any websites (or care to share) that have PG sql
scripts for querying the pg_ views/tables, (there's 000's for Oracle
dba_ v$ views). I'm after storage (sizes etc) info regarding the
applications tables/indexes, also how can I format the output-ted
columns into a more readable format.
Many thanks for any assistance.
Cheers,
Nigel
Communications on or through ioko's computer systems may be monitored or recorded to secure effective system operation and for other lawful purposes.
Unless otherwise agreed expressly in writing, this communication is to be treated as confidential and the information in it may not be used or disclosed except for the purpose for which it has been sent. If you have reason to believe that you are not the intended recipient of this communication, please contact the sender immediately. No employee is authorised to conclude any binding agreement on behalf of ioko with another party by e-mail without prior express written confirmation.
ioko365 Ltd, Innovation Close, York Science Park, York, YO10 5ZD, ENGLAND.
Tel +44 (0) 1904 438 000. VAT reg 656 2443 31. Reg no 3048367. All rights reserved.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PG SQL scripts
@ 2005-04-21 17:36 Thomas F.O'Connell <tfo@sitening.com>
parent: Nigel Bishop <Nigel.Bishop@ioko.com>
0 siblings, 0 replies; 2+ messages in thread
From: Thomas F.O'Connell @ 2005-04-21 17:36 UTC (permalink / raw)
To: Nigel Bishop <Nigel.Bishop@ioko.com>; +Cc: pgsql-admin
For size information, see contrib/dbsize in the source tree.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Apr 21, 2005, at 10:25 AM, Nigel Bishop wrote:
> Hi,
>
> Does anyone know of any websites (or care to share) that have PG sql
> scripts for querying the pg_ views/tables, (there's 000's for Oracle
> dba_ v$ views). I'm after storage (sizes etc) info regarding the
> applications tables/indexes, also how can I format the output-ted
> columns into a more readable format.
>
> Many thanks for any assistance.
>
> Cheers,
> Nigel
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-04-21 17:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-21 15:25 PG SQL scripts Nigel Bishop <Nigel.Bishop@ioko.com>
2005-04-21 17:36 ` Thomas F.O'Connell <tfo@sitening.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox