[ADMIN]Table Field problem

2003-10-30 Thread Monica Robustelli
Dear All, I have updated the release of my Postgres Database, from 7.0 to 7.3. From the old version, I effected the following query to retrieve type and length of a specific table field: select *from pgadmin_tables where (table_name='.$strTableName.') AND (column_name='.$strColumName.') How I

[ADMIN]Retrieve Data Type

2003-10-28 Thread Monica Robustelli
Dear All, I have updated the release of my Postgres Database, from 7.0 to 7.3. From the old version, I effected the following query to retrieve type and length of a specific table field: select *from pgadmin_tables where (table_name='.$strTableName.') AND (column_name='.$strColumName.') How I

[ADMIN]Restore Problem

2003-10-20 Thread Monica Robustelli
Hi all. I've a problem with a database restoring. I've executed the dump command from a Linux 6.8 Red Hat version, Postgres 7.1: this file executes a corrected restore under itself. If I transfer the backup file to another Linux machine, Red Hat 9, Postgres 7.3, I'v some problem during the

[ADMIN] Installazione Postgres

2003-07-09 Thread Monica Robustelli
Ho installato Postgres 7.3.2 su macchina Red Hat 9! Ho configurato Apache a php correttamente, senza alcun errore! Adesso non riesco a far comunicare il php con Postgres, ho un errore sulla connessione! Questo dipende dalla configurazione del file pg_hba.conf? Cosa devo dichiarare? Devo fare