[ADMIN] Table size

2007-06-14 Thread Shyam Sunder Rai
Hi, How can I calculate a table size in postgres ? Help please.. Regards, Shyam Sunder Rai

Re: [ADMIN] Table size

2007-06-14 Thread Andreas 'ads' Scherbaum
Hello, On Thu, 14 Jun 2007 18:10:15 +0530 Shyam Sunder Rai wrote: > How can I calculate a table size in postgres ? thats in the docu: Docu -> The SQL Language -> Functions and Operators -> System Administration Functions http://www.postgresql.org/docs/8.2/interactive/functions-admin.html K

Re: [ADMIN] Table size

2007-06-14 Thread Michael Fuhr
On Thu, Jun 14, 2007 at 06:10:15PM +0530, Shyam Sunder Rai wrote: > How can I calculate a table size in postgres ? To find the size of an existing table use pg_relation_size() or pg_total_relation_size() (8.1 and later; in earlier versions use the functions in contrib/dbsize). http://www.postgre

[ADMIN] copying tables from as400 to pg with dbi link

2007-06-14 Thread Raul Retamozo
Hi. Im trying to copying table estructure & data from as400(db2) with dbi link but im stuck in how do I have to install dbi link over windows , I ve perl (active perl) so I added plperlu (and plperl) language to my database's languagesWhen I've been executing dbi_link.sql but when I write te

Re: [ADMIN] [GENERAL] psql : Error: Cannot stat /pgdata/8.2/main

2007-06-14 Thread Pascal Hakim
On Wed, Jun 13, 2007 at 09:45:52AM -0400, Tom Lane wrote: > Joost Kraaijeveld <[EMAIL PROTECTED]> writes: > > I have moved my database files from their default location to their own > > partition on with their own controller and disks. PostgreSQL works OK > > and I can connect with Pgadmin (Debian

Re: [ADMIN] copying tables from as400 to pg with dbi link

2007-06-14 Thread David Fetter
Raul Retamozo <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding quoted-printable, charset: iso-8859-1, 18 lines --] > > Hi. Im trying to copying table estructure & data from as400(db2) > with dbi link but im stuck in how do I have to install dbi link over > windows , I ve perl (active perl) so