postgres copy syntax code example

Example 1: copy table postgres

CREATE TABLE new_table AS 
TABLE existing_table;

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