[GENERAL] How to import *.sql file to postgresql database

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? Best Regards,

Re: [GENERAL] How to import *.sql file to postgresql database

2010/7/18 Andre Lopes lopes80an...@gmail.com 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? Best Regards, Hi, you can do that for example using the following command: psql database

Re: [GENERAL] How to import *.sql file to postgresql database

2010/7/18 Andre Lopes lopes80an...@gmail.com: 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? Best Regards, From manual [1] 24.1.1. Restoring the dump: psql dbname infile Osvaldo [1]

Re: [GENERAL] How to import *.sql file to postgresql database

Thanks for the reply, I have this 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] I have set the client encoding to

Re: [GENERAL] How to import *.sql file to postgresql database

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

Re: [GENERAL] How to import *.sql file to postgresql database

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

Re: [GENERAL] How to import *.sql file to postgresql database

2010/7/18 Andre Lopes lopes80an...@gmail.com: 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

Re: [GENERAL] How to import *.sql file to postgresql database

On 18/07/10, Andre Lopes (lopes80an...@gmail.com) wrote: 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