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 Dhol

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 VARCHAR(

[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 VAR

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 s

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 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. whenever i use this > postgres d

[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