Re: reading cvs logs with pgadmin queries

On 09/19/2013 05:47 AM, Dave Cramer wrote:
> pgadmin uses multi line queries and copy from 'cvslogs' cannot read them.
>
> Does anyone have a work around or other solution ?

It worked here for me:

test=# INSERT INTO

big_int_test
VALUES
(6.7);

COPY postgres_log FROM
'/usr/local/pgsql/data/pg_log/postgresql-2013-09-19_070152.csv' WITH csv;

-[ RECORD 7 ]----------+-----------------------------------------------
log_time | 2013-09-19 07:04:42.422-07
user_name | aklaver
database_name | test
process_id | 8281
connection_from | [local]
session_id | 523b0401.2059
session_line_num | 4
command_tag | idle
session_start_time | 2013-09-19 07:02:41-07
virtual_transaction_id | 2/30
transaction_id | 0
error_severity | LOG
sql_state_code | 00000
message | statement: INSERT INTO
| big_int_test
| VALUES
| (6.7);
detail |
hint |
internal_query |
internal_query_pos |
context |
query |
query_pos |
location |
application_name | psql

What are the errors you are seeing?

>
> Dave Cramer
>
> dave.cramer(at)credativ(dot)ca
> http://www.credativ.ca

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com