[ADMIN] find a table name

2003-12-06 Thread Ashok Chauhan
hi In postgresql all databases are stored in /data/base directory in numbers form and all the related tables with that database are stored in that directory again in numbers form. so there is any command or query to see the original table names. just like:- select * from pg_stat_database; for d

[ADMIN] find a table name

2003-12-06 Thread Ashok Chauhan
hi In postgresql all databases are stored in /data/base directory in numbers form and all the related tables with that database are stored in that directory again in numbers form. so there is any command or query to see the original table names. just like:- select * from pg_stat_database; for d

[ADMIN] insert & update query

2003-12-06 Thread Ashok Chauhan
hi In postgresql any mechanism for store insert & update queries of a particular database. so that after sometime i can use those queries. plz help me. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if y

[ADMIN] find table name

2003-12-06 Thread Ashok Chauhan
hi In postgresql all databases are stored in /data/base directory in numbers form and all the related tables with that database are stored in that directory again in numbers form. so there is any command or query to see the original table names. just like:- select * from pg_stat_database; for da

Re: [ADMIN] problem backup

2003-12-06 Thread Sai Hertz And Control Systems
Dear Ramesh PAtel , Will you like to tell us what version are you using i have three database on one server. when i backup is done complete. but after backup my pc's speed is very slow. it is requery to restart PC. try doing vaccumdb Regards, V kashyap ---(end o

[ADMIN] Can someone tell me the default installation directory for PostgreSQL 7.4 on linux ?

2003-12-06 Thread Daniel Fitzgerald
I'm a newbie. I just installed it ( from RPMs at the .org for SUSE 8.2 ) and I can't find it anywhere on my hard drive. I can see the package listed in YaST and psql is in the /usr/bin directory. I tried 'find' and 'whereis' to no avail. I installed the docs RPM as well and haven't a clue how t

Re: [ADMIN] Can someone tell me the default installation directory

2003-12-06 Thread Gémes Géza
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Daniel Fitzgerald írta: | I'm a newbie. I just installed it ( from RPMs at the .org for SUSE 8.2 ) | and I can't find it anywhere on my hard drive. I can see the package | listed in YaST and psql is in the /usr/bin directory. I tried 'find' and | 'where