Excel and pgSQL
- by running4surival
How do I import data from a excel sheet onto a PGSQL database on linux?
Search Results
Search found 5 results on 1 pages for 'running4surival'.
Page 1/1 | 1
-
-
importing csv file into pgsql
- by running4surival
ok im trying to upload this csv file onto my table in pgsql but im getting this error ERROR: invalid input syntax for integer: "mlname,mfname,slname,sfname,address,postalcode,membershiptype,hphone,email" CONTEXT: COPY members2, line 1, column id: "mlname,mfname,slname,sfname,address,postalcode,membershiptype,hphone,email" i really understand why im getting this error, both my table and my csv file have the same column namesRead the article
-
Handling apostrophes, php and pgsql
- by running4surival
For my forms, I'm using pg_escape_string on every field before I insert them into the database. So I get something like firstname='O''reilly'. But when I try to print that out, I get O''reily, 2 apostrophes. Shouldn't it only 1 apostrophe, O'reilly? This isnt a debugging problem, im just wondering if you have firstname='O''reilly', how do you print that so it is just O'reilly instead of O''reilly?Read the article
-
pgSQL query error
- by running4surival
i tried using this query: "SELECT * FROM guests WHERE event_id=".$id." GROUP BY member_id;" and I'm getting this error: ERROR: column "guests.id" must appear in the GROUP BY clause or be used in an aggregate function can anyone explain how i can work around this?Read the article
-
Firefox displaying username and password in all my forms?
- by running4surival
I have a website, and when I tell Firefox to remember my username and password for the website, it is causing the username and password to display in all forms on my website, such as registration form. It is only supposed to do this on the login form. Does anyone know a fix for this?Read the article
