本实验将瀚高数据库(HighGo Database)下的public.test表导入到schema lk下
1、验证public.test表存在及其表中数据
[highgo@sourcedb ~]$ psql -d highgo -U highgopsql (3.1.4)
Type "help" for help.
highgo=# \dt
List of relations
Schema | Name | Type | Owner
--------+----------+-------+--------
...
public | persons | table | highgo
public | students | table | highgo
public | t | table | highgo
...
(17 rows)
highgo=# select * from pg_tables where tablename='test';
schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers
------------+-----------+------------+------------+------------+----------+