From: | Andre Lopes <lopes80andre(at)gmail(dot)com> |
---|---|
To: | Edoardo Panfili <edoardo(at)aspix(dot)it> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to import *.sql file to postgresql database |
Date: | 2010-07-18 21:04:42 |
Message-ID: | AANLkTimA00lTinau4Se8zlMiUTzPfJOAl5N7VokmDrvx@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If I do this command gives me the same error:
[quote]
ERROR: invalid byte sequence for encoding "UTF8": 0xff
HINT: This error can also happen if the byte sequence does not match the
encoding expected by the server, which is controlled by "client_encoding".
[/quote]
What more can I do?
Best Regards,
On Sun, Jul 18, 2010 at 9:11 PM, Edoardo Panfili <edoardo(at)aspix(dot)it> wrote:
> On 18/07/10 22.06, Andre Lopes wrote:
>
>> Hi,
>>
>> I have a DUMP file with INSERT's commands. I need to import this data to
>> postgresql database with the "psql" command.
>>
>> How can I do this task?
>>
>
> I think
>
> psql -U user_name database_name <dump_file
>
> EDoardo
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Friedrich | 2010-07-18 21:34:50 | Re: NASA needs Postgres - Nagios help |
Previous Message | Andre Lopes | 2010-07-18 20:24:14 | Re: How to import *.sql file to postgresql database |