[HELP] - unable to connect to db using psql or pgadmin

[Justin-JHG]

I was running the demo in codespace

I followed the guide to export the token generated as password

export PGPASSWORD={"eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsIng1dCI...........VPNUlKeXlxUjZqekRTNWlBYnBlNDJKdyJ9"}

and then run the following
$ psql -h $(azd env get-value POSTGRES_HOST) -U $(azd env get-value POSTGRES_USERNAME) -d $(azd env get-value POSTGRES_DATABASE) -p 5432

but getting this error:

psql: error: connection to server at "justin-test-3a*****bi-postgresql.postgres.database.azure.com" (172.177.167.194), port 5432 
failed: FATAL:  The access token has invalid format. 
Please ensure the token is passed exactly as returned by the authentication endpoint and retry.

connection to server at "justin-test-3a******zbi-postgresql.postgres.database.azure.com" (172.177.167.194), port 5432 
failed: FATAL:  no pg_hba.conf entry for host "20.227.141.210", user "adminupjcfh45d******" database "postgres", no encryption

[Justin-JHG]

I tried the following and it worked

export PGPASSWORD=$(az account get-access-token --resource-type oss-rdbms --query "[accessToken]" -o tsv)

ref: https://learn.microsoft.com/en-gb/azure/postgresql/flexible-server/how-to-configure-sign-in-azure-ad-authentication

not sure why the export PGPASSWORD={token} doesn't work