[SQL] sql foregein key

2000-06-12 Thread GANESH KUMAR
sir , i am working 6.5.2 postgresql in creation foregein key in table syntax i am writing is 1)create table gk (sno int primary key); 2)create table kk (sno int references gk, sname varchar(2)); i am getting message like this foregein key is not implemented . please write which version

[SQL] BACK UP

2000-06-10 Thread GANESH KUMAR
I WANT TO TAKE BACK UP DAILY WORK DONE WHAT IS PROCEDURE IS THERE ANY COMMMAND GANESH __ Do You Yahoo!? Yahoo! Photos -- now, 100 FREE prints! http://photos.yahoo.com

[SQL] AUTO INCREMENT

2000-06-10 Thread GANESH KUMAR
i am searching for autoincrement in table in table employee i want give empno as autoincrement is there any syntax like this create table emp (empno integer auto_increment); send reply ganesh __ Do You Yahoo!? Yahoo! Photos -- now, 100 FREE