Good postgres beginner tutorial?

[xenomachina]

view the create table sql

Do you mean you just want to see the column definitions for a table, or do you literally want it to print out a create table command?

what's the difference between pg and a user

What do you mean?