[SQL] failing to connect to postgresql with php

2011-01-17 Thread victor katemana
i have installed postgres 8.4 server in ubuntu 10.04, clearly following all procedures. what is disappointing me i cant establish connection to the database server when am configuring postgres with php. whenever i use this postgres database function i dont even receive an error message. the server

Re: [SQL] failing to connect to postgresql with php

2011-01-17 Thread Viktor Bojović
On Mon, Jan 17, 2011 at 9:42 AM, victor katemana developervick...@gmail.com wrote: i have installed postgres 8.4 server in ubuntu 10.04, clearly following all procedures. what is disappointing me i cant establish connection to the database server when am configuring postgres with php.

Re: [SQL] failing to connect to postgresql with php

2011-01-17 Thread Marcin Mirosław
W dniu 17.01.2011 09:42, victor katemana pisze: psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket /var/run/postgresql/.s.PGSQL.5432? can someone help me out please Check permissions to the

[SQL] Help needed in skipping column for copy command

2011-01-17 Thread Amar Dhole
I have table created as follows CREATE TABLE D_2147483927_2147484848_TAB( CP VARCHAR(256) , CPR VARCHAR(256) , CHOUSENO VARCHAR(256) , CSTREET VARCHAR(256) , CLOCALITY VARCHAR(256) , CCITY VARCHAR(256) , CPROVINCE VARCHAR(256) , CCOUNTRY VARCHAR(256) , CZIP VARCHAR(256) , CCO

Re: [SQL] Help needed in skipping column for copy command

2011-01-17 Thread Adrian Klaver
On 01/17/2011 05:59 AM, Amar Dhole wrote: I have table created as follows CREATE TABLE D_2147483927_2147484848_TAB( CP VARCHAR(256) , CPR VARCHAR(256) , CHOUSENO VARCHAR(256) , CSTREET VARCHAR(256) , CLOCALITY VARCHAR(256) , CCITY VARCHAR(256) , CPROVINCE VARCHAR(256) , CCOUNTRY

Re: [SQL] Help needed in skipping column for copy command

2011-01-17 Thread Russell Galyon
COPY D_2147483927_2147484848_TAB ( CP , CPR , CHOUSENO , CSTREET , CLOCALITY , CCITY , CPROVINCE , CCOUNTRY , CZIP ) FROM 'one.txt' WITH DELIMITER ',' QUOTE '' csv HEADER; On Mon, Jan 17, 2011 at 7:59 AM, Amar