[ADMIN] find a table name
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 databases. thank you have a nice day. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[ADMIN] find a table name
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 databases. thank you have a nice day. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[ADMIN] insert & update query
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 your joining column's datatypes do not match
[ADMIN] find table name
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 databases. thank you have a nice day. ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [ADMIN] problem backup
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 of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[ADMIN] Can someone tell me the default installation directory for PostgreSQL 7.4 on linux ?
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 to even open them as well. Any help at all is appreciated. Thank you. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [ADMIN] Can someone tell me the default installation directory
-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 | 'whereis' to no avail. | | I installed the docs RPM as well and haven't a clue how to even open | them as well. | Any help at all is appreciated. Thank you. | | | ---(end of broadcast)--- | TIP 5: Have you checked our extensive FAQ? | | http://www.postgresql.org/docs/faqs/FAQ.html In a console window type rpm -qa | grep postgres then for each interesting line in the list obtained type rpm -ql interestingittemsname Good Luck! Geza Gemes -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/0lrD/PxuIn+i1pIRAi6LAJ9PA2iry2r0So0U2pfp3CkkAVqJYACgrJrw HxFSRX3cQTOjmtNkJtwVHpQ= =dAfg -END PGP SIGNATURE- ---(end of broadcast)--- TIP 8: explain analyze is your friend
