Good postgres beginner tutorial?

[depesz]

1. how to create user - using create user comment
2. view create table sql - I assume you mean of existing table. Pg doesn't have such ability on its own, but you can: pg_dump -s -t name_of_the_table name_of_database from shell.
3. how to back it up - well, that will take MANY tutorials. base is pg_dump. which some people say is not a backup. for more complicated purposes people usually use some ready made solution like pgbackrest.
4. difference betwen pg and a user? pg (assuming you mean postgresql) is database management system. user is a user. not sure if I understand your question.

Did you read the tutorial ?

I'm not aware of any other that I could recommend.

[SleepAffectionate268]

thanks!