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.klaver@gmail.com