Обсуждение: BUG #15870: You can't see the table after executing the table-building statement with \i
BUG #15870: You can't see the table after executing the table-building statement with \i
От
PG Bug reporting form
Дата:
The following bug has been logged on the website: Bug reference: 15870 Logged by: 强 魏 Email address: 1726002692@qq.com PostgreSQL version: 12beta2 Operating system: CentOS Linux release 7.6.1810 (Core) GCC-4.8.5 Description: postgres@127.0.0.1:5432[cmis_to_mysql]#\i /home/postgres/aa/cmis_to_mysql.sql SET Time: 0.550 ms SET Time: 0.573 ms SET Time: 0.910 ms SET Time: 1.353 ms SET Time: 1.049 ms +------------+ | set_config | +------------+ | | +------------+ (1 row) Time: 2.336 ms SET Time: 0.298 ms SET Time: 0.256 ms SET Time: 0.203 ms SET Time: 0.273 ms SET Time: 0.184 ms SET Time: 0.387 ms CREATE TABLE Time: 56.455 ms ALTER TABLE Time: 3.026 ms COMMENT Time: 8.306 ms COMMENT Time: 2.670 ms COMMENT Time: 1.989 ms COMMENT Time: 3.834 ms COMMENT Time: 2.543 ms COPY 12 Time: 4.449 ms CREATE INDEX Time: 8.782 ms CREATE INDEX Time: 4.601 ms postgres@127.0.0.1:5432[cmis_to_mysql]#\d Did not find any relations. postgres@127.0.0.1:5432[cmis_to_mysql]#\c cmis_to_mysql You are now connected to database "cmis_to_mysql" as user "postgres". postgres@127.0.0.1:5432[cmis_to_mysql]#\d List of relations +--------+---------------+-------+----------+ | Schema | Name | Type | Owner | +--------+---------------+-------+----------+ | public | cmis_to_mysql | table | postgres | +--------+---------------+-------+----------+ (1 row)
Re: BUG #15870: You can't see the table after executing the table-building statement with \i
От
Sergei Kornilov
Дата:
Hello Seems you tried import something from pg_dump result. Please check query text with set_config response in yours log. I thinkthis is: SELECT pg_catalog.set_config('search_path', '', false); If so all works as expected and not related to \i command. regards, Sergei