有一个名为backupfiel的Postgresql备份,如下
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.5.10
-- Dumped by pg_dump version 9.5.10
SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;
SET search_path = xml, pg_catalog;
--
-- Data for Name: t_sys_data; Type: TABLE DATA; Schema: xml; Owner: -
--
COPY t_sys_data (sys_data_id, copyright) FROM stdin;
1 <copyright>User acknowledges that Fairview Research and its third party providers retain all right, title and interest in and to this xml under applicable copyright laws. User acquires no ownership rights to this xml including but not limited to its format. User hereby accepts the terms and conditions of the License Agreement.</copyright>
\.
--
-- Name: t_sys_data_sys_data_id_seq; Type: SEQUENCE SET; Schema: xml; Owner: -
--
SELECT pg_catalog.setval('t_sys_data_sys_data_id_seq', 1, false);
--
-- PostgreSQL database dump complete
--
如何恢复到Postgresql?我试过用下面的代码。
psql -U postgres database < backupfile
但是返回错误:“t_sys_data” does not exist
这个表我已经建立在数据库database里面了