Problema con importar base de datos postgresql

[iniciopublic]

Hola a todos , tengo un problema con exportar una base de datos desde pgadmin local ( mi laptop) y importarlo en el pgadmin de un hosting

al entrar al pg admin , ventana sql y subir el respaldo con extension .backup me dice lo siguiente :

posgrado.backup:1: ERROR: syntax error at or near "PGDMP"
LINE 1: PGDMP

^
posgrado.backup:1030:
posgrado.backup:1032: ERROR: invalid byte sequence for encoding "UTF8": 0x93
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".
posgrado.backup:1038: ERROR: invalid byte sequence for encoding "UTF8": 0xb2
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".
posgrado.backup:1053: ERROR: invalid byte sequence for encoding "UTF8": 0xbd
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".
posgrado.backup:1055: ERROR: invalid byte sequence for encoding "UTF8": 0xb1
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".

Hasta por hacer un create table

Código:

CREATE TABLE(
   ID   INT              NOT NULL,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25) ,
   SALARY   DECIMAL (18, 2),       
   PRIMARY KEY (ID)
);

Me da el siguiente error

Código HTML:

Error de SQL:

ERROR:  syntax error at or near "CREATE"
LINE 1: SELECT COUNT(*) AS total FROM (CREATE TABLE(
                                       ^

En la declaración:

SELECT COUNT(*) AS total FROM (CREATE TABLE(
   ID   INT              NOT NULL,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25) ,
   SALARY   DECIMAL (18, 2),       
   PRIMARY KEY (ID)
)) AS sub

¿Que pasa hay? ¿que puedo hacer?