The code is below . libname x2 postgres server="xxxxxxxxx" port=xxx database="xxx" schema="public" user=mppcra password="mppcra@123" client_encoding="lantin1" ;
option sastrace='d,,d,d' sastraceloc=saslog nostsuffix;
proc sql;
create table x2.class_clas_testxxxx(bulkload=YES bl_psql_path='/opt/mppdb_client/psql/psql' bl_delete_datafile=no)
as
select * from sashelp.cars;
quit; The before's encoding problem don't have. The error ************** Begin: PSQL Log File **************
psql_exec: warning: extra command-line argument "dbname=xxxx" ignored
psql_exec: warning: extra command-line argument "host=xxxxx" ignored
psql_exec: warning: extra command-line argument "port=xxxx" ignored
psql_exec: warning: extra command-line argument "password=mppcra@123" ignored
psql_exec: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/opt/huawei/Bigdata/mppdb/mppdb_tmp/.s.PGSQL.5432"?
************** End: PSQL Log File **************
... View more