curl statement issue and UTF-8 encoding issue

[jjfrost]

Couple of further items to consider updating in this article:

1.) From the psql command prompt, the curl command such as in [! curl -O https://examples.citusdata.com/users.csv] results in "permission denied" error . Workaround is to download this file locally, then run the \copy command pointing to the local downloaded file path in the from statement as in: [\copy github_users from 'c:\mydata\users.csv' WITH CSV]

2.) If running a command prompt in Windows to run psql command, you need to set the CLIENT_ENCODING to 'utf8' before running the copy commands. If you do not, the copy command for events.csv [\copy github_events from 'events.csv' WITH CSV] will result in an error [ERROR: character with byte sequence 0x8f in encoding "WIN1252" has no equivalent in encoding "UTF8"]

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: b9b65f64-c521-3799-b833-9ac27213e927
• Version Independent ID: 0d6e2a8b-043b-7cdd-4e19-82c03c803c16
• Content: Azure Database for PostgreSQL – Hyperscale (Citus) (preview) quickstart
• Content Source: articles/postgresql/quickstart-create-hyperscale-portal.md
• Service: postgresql
• Sub-service: hyperscale-citus
• GitHub Login: @jonels-msft
• Microsoft Alias: jonels

[mimckitt]

Thanks for the feedback! I have assigned the issue to the content author to investigate further and update the document as appropriate.

[jjfrost]

Cool, thanks Micah! I should have mentioned that for #2 in my first comment, the command for the client encoding needed is:

SET CLIENT_ENCODING TO 'utf8';

This worked to solve the error I mentioned by running it before the /copy commands.

[jonels-msft]

@jjfrost thanks, I'll test your suggestions and update the docs.

On my machine the default psql client_encoding is UTF8, so I overlooked the problem. Just out of curiosity, is WIN1252 the default value on your machine?

[jjfrost]

@jonels-msft Great, thanks so much. Yes, correct, WIN1252 was the default upon install of psql and PostgreSQL client tools on my machine. My OS is Windows 10 Enterprise (version 1809) and my PostgreSQL client tools version is 11.3 (64 Bit).

[Mike-Ubezzi-MSFT]

@jonels-msft Want to follow-up on this item to see if the client_encoding detail has been added to the document?

[JasonWHowell]

@Mike-Ubezzi-MSFT I remember from email that @craigkerstiens is the docs backup contact for Joe.

Looks like there are two issues reported on this same article - #31719 and #31546

Thanks, Jason

[jonels-msft]

1.) From the psql command prompt, the curl command such as in [! curl -O https://examples.citusdata.com/users.csv] results in "permission denied" error .

Interesting, the following commands worked for me when I ran them in psql from the Windows 10 Command Prompt application:

\! curl -O https://examples.citusdata.com/users.csv
\! curl -O https://examples.citusdata.com/events.csv

• Did you run the command exactly as shown, with the backslash?
• Did you run it in psql locally on your computer?
• Did you start psql in a working directory for which you have write access?

2.) If running a command prompt in Windows to run psql command, you need to set the CLIENT_ENCODING to 'utf8' before running the copy commands.

Yep, confirmed that this worked for me on windows as well. I'll add that to the quickstart before the \copy commands.

[jonels-msft]

@jjfrost can you give me more information about the permission denied error you encountered? I have a few questions above about it.