[postgres] Forum Topics

I made this code: INSERT into author(authorfirstname1, authorlastname1,authorfirstname2, authorlastname2) select '".addslashes($_POST['authorfirstname1'])."','".addslashes($_POST['authorlastname1'])."','".addslashes($_POST['authorfirstname2'])."','".addslashes($_POST['authorlastname2'])."' from author where not exists(select authorfirstname1, authorlastname1, authorfirstname2, authorlastname2 from author where author.authorfirstname1='".addslashes($_POST['authorfirstname1'])."' and author.authorlastname1='".addslashes($_POST['authorlastname1'])."' and author.authorfirstname2='".addslashes($_POST['authorfirstname2'])."' and author.authorlastname2='".addslashes($_POST['authorlastname2'])."' ); The point of this code should be that it checks, if a value allready exists in database and if …

Hello friends, I am working an a section of application which needs to Parse CSV Logs generated by PostgreSql server. - The Logs are stored C:\Program Files\PostgreSQL\9.0\data\pg_log - The Server version in 9.0.4 - The application is developed in C Sharp * The basic utility after Parse the Log is …