C:\Program Files\PostgreSQL\15\bin

cd C:\Program Files\PostgreSQL\15\bin


"C:\Intel\dreamhome\dreamhome.sql"

C:\Intel\dreamhome\dreamhome.sql


psql -U username -f backupfile.sql


psql -U postgres -f dreamhome.sql

OLD POSTGRES VERSIONS

psql -U your_user_name your_db_name < your_dump_file

psql -U postgres dreamhome < dreamhome.sql

psql -U postgres dreamhome < "C:\Intel\dreamhome\dreamhome.sql"

NEW POSTGRES VERSIONS

Windows

psql -U <username> -d <database name> -1 \i D:/Database/file.sql

psql -U postgres -d dreamhome -1 \i C:/Intel/dreamhome/dreamhome_tables.sql

Linux 

psql -U postgres -d dreamhome -1 \i C:\Intel\dreamhome\dreamhome.sql

SELECT propertyNo, street, city, postcode FROM PropertyForRent WHERE staffNo IS NULL ;

SELECT MAX (rent) FROM PropertyForRent WHERE type = 'flat' AND rooms = '3'

SELECT fName, lName FROM staff WHERE branchNo = IN(SELECT branchNo FROM Branch WHERE city = ‘london’ );