https://communities.sas.com/t5/Administration-and-Deployment/PostGres-tables-on-SASWebInfrastructurePlatformDataServer/m-p/961257#M29717 The SAS Web Infrastructure Platform Data Server is a postgres database, so you can use any postgres client to connect to it. <BR /><BR />From your description, it is not clear what issue you are encountering when trying to use the psql client. However to be able to use the psql CLI in that path, you'd need to set some environment variables as well as some options to that command line. <BR /><BR />You could run this to set the environment variables necessary to run psql:<BR /># Set a variable to store the base path for the psql client.<BR />PGHOME=$SASHOME/SASWebInfrastructurePlatformDataServer/9.4<BR /># Put the bin subdir into PATH<BR />PATH=$PATH:$PGHOME/bin<BR /># Put the lib subdir into LD_LIBRARY_PATH<BR />export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PGHOME/lib<BR /><BR />This will allow you to run "psql" without specifying the full path.<BR /><BR />Then run psql with the options:<BR />-p 9432 (the default postgres port is 5432, WIP Data Server runs on 9432 by default)<BR />-U dbmsowner (the database user)<BR />-d SharedServices (the database name)<BR /><BR />This will prompt you for the password for the dbmsowner user, so you will need to know that.<BR /> Fri, 07 Mar 2025 18:19:36 GMT gwootton 2025-03-07T18:19:36Z https://communities.sas.com/t5/Administration-and-Deployment/PostGres-tables-on-SASWebInfrastructurePlatformDataServer/m-p/961254#M29716 <P>Is it possible to browse through the PostGre tables on the&nbsp;SASWebInfrastructurePlatformDataServer configuration?. I have a requirement to provide the table and sample data being stored in these tables and I am unable to login to this database using</P><P>&nbsp;</P><P>$SASHOME/SASWebInfrastructurePlatformDataServer/9.4/bin/psql</P> Fri, 07 Mar 2025 17:17:23 GMT https://communities.sas.com/t5/Administration-and-Deployment/PostGres-tables-on-SASWebInfrastructurePlatformDataServer/m-p/961254#M29716 Key123 2025-03-07T17:17:23Z https://communities.sas.com/t5/Administration-and-Deployment/PostGres-tables-on-SASWebInfrastructurePlatformDataServer/m-p/961257#M29717 The SAS Web Infrastructure Platform Data Server is a postgres database, so you can use any postgres client to connect to it. <BR /><BR />From your description, it is not clear what issue you are encountering when trying to use the psql client. However to be able to use the psql CLI in that path, you'd need to set some environment variables as well as some options to that command line. <BR /><BR />You could run this to set the environment variables necessary to run psql:<BR /># Set a variable to store the base path for the psql client.<BR />PGHOME=$SASHOME/SASWebInfrastructurePlatformDataServer/9.4<BR /># Put the bin subdir into PATH<BR />PATH=$PATH:$PGHOME/bin<BR /># Put the lib subdir into LD_LIBRARY_PATH<BR />export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PGHOME/lib<BR /><BR />This will allow you to run "psql" without specifying the full path.<BR /><BR />Then run psql with the options:<BR />-p 9432 (the default postgres port is 5432, WIP Data Server runs on 9432 by default)<BR />-U dbmsowner (the database user)<BR />-d SharedServices (the database name)<BR /><BR />This will prompt you for the password for the dbmsowner user, so you will need to know that.<BR /> Fri, 07 Mar 2025 18:19:36 GMT https://communities.sas.com/t5/Administration-and-Deployment/PostGres-tables-on-SASWebInfrastructurePlatformDataServer/m-p/961257#M29717 gwootton 2025-03-07T18:19:36Z