backup database with copy postgresql code example

Example 1: copy table postgres

CREATE TABLE new_table AS 
SELECT
*
FROM
    existing_table
WHERE
    condition;

Example 2: postgresql copy backup table

psql -U postgres -d postgres < "C:\Users\Nilay\Desktop\IBS\files\fddcerfltseg\fddcerfltseg.sql"> C:\Users\Nilay\Desktop\IBS\files\fddcerfltseg\logerror.log