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@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
