How do you save a postgresql query output as a table? Similar to the maketable query within Access. I want to be able to join other tables to the query output and making a new table would make life good. I am using Navicat to execute queries.
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
If you have a select statement you can execute a CTAS
CREATE TABLE <table name> AS (
SELECT STATEMENT
)
