[GENERAL] Copy from text file

2006-06-22 Thread Ricardo Vaz
Hi, It is possible to copy data from text file (CSV) ignoring some columns of this text file? Thanks, Ricardo Vaz Tribunal de Contas do Estado de São Paulo Diretoria de Tecnologia Rua Venceslau Brás, 183 - 2º andar (11) 3292-3266 ramal 3640 [EMAIL PROTECTED] -- Esta mensagem foi verificada

[GENERAL] Copy from text file

2006-06-22 Thread Ricardo Vaz
Hi, It is possible to copy data from text file (CSV) ignoring some columns of this text file? Thanks, Ricardo Vaz Tribunal de Contas do Estado de São Paulo Diretoria de Tecnologia [EMAIL PROTECTED] -- Esta mensagem foi verificada pelo sistema de antivírus e acredita-se estar livre de

[GENERAL] Copy from text file

2006-06-22 Thread Ricardo Vaz
Hi, It is possible to copy data from text file (CSV) ignoring some columns of this text file? Thanks, Ricardo Vaz Tribunal de Contas do Estado de São Paulo Diretoria de Tecnologia Rua Venceslau Brás, 183 - 2º andar (11) 3292-3266 ramal 3640 [EMAIL PROTECTED] -- Esta mensagem foi verificada

[GENERAL] Log of CREATE USER statement

2005-12-07 Thread Ricardo Vaz - TCESP
ENCRYPTED PASSWORD 'test'; in the log file it would be registered as: CREATE USER test ENCRYPTED PASSWORD 'md505a671c66aefea124cc08b76ea6d30bb' Thus, the password would be protecting against attacks in log files. Is it possible? Thanks, Ricardo Vaz Tribunal de Contas do

Re: [GENERAL] Dynamically access to field on a RECORD variable

2005-05-03 Thread Ricardo Vaz Mannrich
y_table1') THEN RETURN rec.my1_field; ELSIF (table_name = 'my_table2') THEN RETURN rec.my2.field; ... END; ' LANGUAGE plpgsql; Em Ter, 2005-05-03 às 11:52, Tom Lane escreveu: > Ricardo Vaz Mannrich <[EMAIL PROTECTED]> writes: > > Is it possible? >

[GENERAL] Dynamically access to field on a RECORD variable

2005-05-03 Thread Ricardo Vaz Mannrich
('my_field'); I want the return row in the function executes as: RETURN rec.my_field; Is it possible? Thank you. -- Ricardo Vaz Mannrich <[EMAIL PROTECTED]> ---(end of broadcast)--- TIP 8: explain analyze is your friend