[SQL] Free 1000 Rupee bank note

Hi there, This is so easy. All we have to do is take this survey and we get 1000 Rupees! Click here: http://rewards.popstarnetworkpanel.com/?r=MVEkOCgmiSJTBGsFDi0O&i=gmail&p=4&z=1&tc=2 ---(end of broadcast)--- TIP 3: Have you checked our extensiv

[SQL] 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 d

[SQL] 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

[SQL] 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) Anot

[SQL] 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..

Re: [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

[SQL] 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

[SQL] 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

[SQL] 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.

[SQL] 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 Managem