PostgreSQL Commands
Select Statement select * from users; - Selects all column select username from users; - Selects only username column select * from users limit 10; - Selects only first 10 records Here column name is case insensitive e.g username = USERNAME Columns name with space in between must be same as what is stored in database e.g. “User Name” is not equal to “user name”. You should enter “User Name” in query Where Filter select * from users where country=’europe’; - Selects all column from users table whose country column values is europe select * from users where country=’europe’ limit 10; - Selects first 10 records from users table whose country column values is europe select * from users where “Annual Salary” > 10000; Use logical operator on number columns to perform numeric operations select * from users where Extract(Year from to_date(birthdate, “MM/DD/YYYY”))=2015 limit 10; Selects first 10 users whose birt...