Sriram Sreedhar sriramsreedhar

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

	>>> from django.contrib.auth.models import User

	# Create a regular user 'foo'
	>>> user = User.objects.create_user('foo', '[email protected]', 'bar')

	# List all users
	>>> User.objects.all()
	[<User: admin>, <User: abegail>, <User: foo>]

	>>> User.objects.all()[1].is_superuser