[GENERAL] Free 1000 Rupee bank note
Hi there, Help me by taking this survey. We can both get 1000 Rupees! Click here: http://rewards.popstarnetworkpanel.com/?r=EVEkOCgmiSJTBGsFDi0O&i=gmail&p=4&z=1&tc=2 ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[GENERAL] pgcrypto-crypt
dear all, i want to encrypt and decrypt one of the fields in my table (i.e-password field) i have searched and with the help of pgcrypto package, using function "crypt", i am able to encrypt my data, but there is nothing which i found to decrypt that same data, plz anybody give me the function to decrypt that encrypted value. plz reply asap-- Thanks & Regards,AkhileshDAV Institute of ManagementFaridabad(Haryana)GSM:-(+919891606064) (+911744293789)"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"
[GENERAL] encryption/decryption
hi all, just to ask u all one thing regarding encryption/decryption. i am migrating my database from mysql to pgSQL using a php script. in mysql there is a table 'users' where a field 'password' is there of type varchar(30), and is encrypted using AES algorithm, and when i check all the records in mysql it looks like:- mysql> select * from USERS; ++--+--+---++---+ | id | name | password | password_modified | created_on | admin | ++--+--+---++---+ | 1 | Admin | \u\u\u6fde\u\u \u/|\u9A | Y | 2005-08-10 | Y | | 2 | sangeeta | \u\uX\u\u\u0215\u0635\ukg\ug\u | Y | 2005-08-13 | Y | | 3 | check1 | [EMAIL PROTECTED] | Y | 2005-08-10 | Y | | 4 | check2 | | Y | 2005-08-10 | N | | 5 | check3 | V[6\u\u\uw\u\u\u\u.C'\u | Y | 2005-08-10 | N | | 16 | user | 5\u\u\u\u<\u.\u\u\u\u^k | Y | 2005-08-10 | N | | 6 | admin | \u77\u\u\us\u\u3h\uM\u%\u | Y | 2005-08-10 | Y | | 17 | anita | \u\u\u\u\u\uH\u"\uhe)U\u | Y | 2005-09-27 | Y | | 1 | Akhilesh | cheeks | y | 2006-04-01 | y | ++--+--+---++---+ 9 rows in set (0.00 sec) (all these "ufff\ufff\ufff<\ufff\U\ufff" the password field is seems as special characters like triangles and rectangles, u can say like chinese characters) now, when i am running my script, then only one record, where name='check2' is copied (because no password is there in this case), but not any other record is displayed. plz help me in this case and do tell what should i do to copy all the records... (any suggestion either at the php/mysql/postgresql level) do help me..plz..!-- Thanks & Regards,AkhileshDAV Institute of ManagementFaridabad(Haryana)GSM:-(+919891606064) (+911744293789)"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"
[GENERAL] regarding join
hi all, below I have created two tables in pgsql with field name as 'name' and 'id' as their datatype 'varchar(15)' and 'integer'. One of the table is:-> chemical=> select * from test1; name | id ---+ akhil | 1 b | 2 c | 3 d | 4 e | 5 f | 6 (6 rows) Another table is:->chemical=> select * from test3; name | id --+ ab | 1 cd | 2 ef | 3 gh | 4 (4 rows) i want the output as:-> name | id ---+ akhil | 1 -from test1 table ab | 1--from test2 table b | 2-from test1 table cd | 2--from test2 table c | 3-from test1 table ef | 3--from test2 table d | 4-from test1 table gh | 4--from test2 table e | 5-from test1 table f | 6-from test1 table i have tried all the joins but it makes different fields for different tables. is there any way out for this kind of output?? (plz reply asap)urgent. THANKS IN ADVANCE -- Thanks & Regards,AkhileshS/W Trainee (EDP), NUCHEM Pvt. Ltd., Faridabad(Haryana)GSM:-(+919891606064)"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"
[GENERAL] input from a external text file......!
Hi All.! I just want to know one thing that is it possible with PGSQL that, if I want to insert and execute a query from a external text file instead of giving it at the pgsql prompt? just like in Oracle the file having query is executed with a '@ filename' statement at the sql prompt..! plz help me and mail me @ [EMAIL PROTECTED], it's urgent. thanks in advance...! (i have searched alot, but didn't found anything)-- Thanks & Regards,AkhileshDAV Institute of ManagementFaridabad(Haryana)GSM:-(+919891606064) (+911744293789) "FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"
Re: [GENERAL] [SQL] regarding grant option
thank you very much sir for your valuable suggestion,but i am talking about direct database query...!On 3/1/06, Alvaro Herrera < [EMAIL PROTECTED]> wrote:AKHILESH GUPTA wrote:> here i have to grant permissions to that user individually for each and > every table by using:> :->> grant ALL ON to ;> GRANT> and all the permissions are granted to that user for that particular table.Yes. If you are annoyed by having to type too many commands, you can write a little shell script to do it for you.--Alvaro Herrerahttp://www.CommandPrompt.com/PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Thanks & Regards,AkhileshDAV Institute of ManagementFaridabad(Haryana)GSM:-(+919891606064) (+911744293789)"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"
[GENERAL] regarding grant option
hi all this is akhilesh from india.i just want to ask one thing regarding grant operation?? i am using pgsql 8.0 on ubuntu 5.10 linux. just tell me the procedure that how can i grant all permissions for a database to any of the other user??? i am using :- :->> grant all privileges on database to ; GRANT :->> grant all ON DATABASE to ; GRANT and the query executes succesfully. but at the other user end, she is not able to access the database given in the above query. here i have to grant permissions to that user individually for each and every table by using: :->> grant ALL ON to ; GRANT and all the permissions are granted to that user for that particular table. i want same results for the entire database. plz help me it's urgent -- Thanks & Regards,AkhileshDAV Institute of ManagementFaridabad(Haryana)GSM:-(+919891606064) (+911744293789)"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"
[GENERAL] to count no of columns in a table
hi all, i just want to know one thing that is there any function in PGSQL which gives me the total number of columns in a table. OR just like we are using count(*), it gives us total number or rows in a table, just like i want to know the total number of columns present in the table plz help me it's urgent THANKS IN ADVANCE! -- Thanks & Regards, Akhilesh DAV Institute of Management Faridabad(Haryana)-INDIA "FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"
[GENERAL] regarding debugging?
hi all, i have a query regarding debbuging in PGSQL. just like there is a debugger in C/C++, where we can check the execution of our program or we can dry run our code, is there aby option or feature with PGSQL for the same purpose that we can check our PGSQL statements? thanks in advance!! (waiting for your response)-- Thanks & Regards,AkhileshDAV Institute of ManagementFaridabad(Haryana)GSM:-(+919891606064) (+911744293789)"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"
[GENERAL] hi all......................!!
hello everybody i am new to this mailing list. this is my first mail to this group. i jussst want to confirm that whether is it possible to update a view or not?? i think you all help me in solving my queries in future...!! -- Thanks & Regards, Akhilesh DAV Institute of Management Faridabad(Haryana) GSM:-(+919891606064) (+911744293789) "FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"