haii..
How can i find the output for this query
1. List the emps whose sal is 4 digit number ending with zero
--> How to count the digits in a salary number
thanks
bhavani
bhavanik
Last Activity: Jun 3 '10, 10:57 AM
Joined: May 26 '10
Location: HYDERABAD,INDIA
-
How to give the privilliges from super user to normal users
I have a question about priviliges. My super user is "hyd" and I have other users like "kit" and "max".
How can i give only select privileges to "kit" and "max" from duper user "hyd"? -
bhavanik started a topic what is the main difference in between function and stored procedures in postgresql.in PostgreSQLwhat is the main difference in between function and stored procedures in postgresql.
The Postgresql have stored procedures or not.If postgres contain stored procedures what is the difference between function and stored procedures in postgresql? -
how to decrypt the user password
How do I decrypt the password of a user? What is the command used for decrypting the encrypted password to normal one?
After entering into postgreSQL database and typing:
postgres=# select * from pg_shadow;
We will be getting the below listed fields..
i am a super user of the database..
password field shows :md5f0101924b02 603efac6788bb7f 096638 as encrypted password in Message Digest 5 algorithm......
No activity results to display