从三个表联接将联合输出保存到一个新表中

Question

我试图将psql查询保存到一个新表中。psql查询如下所示：

select 
(protein.accession, peptide_protein.mutation, peptide_protein.start_position, peptide_protein.end_position, peptide.weight, peptide.sequence)
from peptide
join peptide_protein on peptide_protein.peptide_id = peptide.peptide_id
join organism on organism.organism_id = peptide_protein.organism_id
join protein on peptide_protein.protein_id = protein.protein_id;

当我尝试这样做的时候，我有一个样本：

CREATE TABLE joinedTables AS
Select 
(protein.accession, peptide_protein.mutation, peptide_protein.start_position, peptide_protein.end_position, peptide.weight, peptide.sequence)
from peptide
join peptide_protein on peptide_protein.peptide_id = peptide.peptide_id
join organism on organism.organism_id = peptide_protein.organism_id
join protein on peptide_protein.protein_id = protein.protein_id
order BY peptide.peptide_id;

当我尝试这样做时，我会得到以下错误：

错误:列“行”具有伪类型记录

有人能帮我吗？太棒了！

Answer 1

从SELECT列表中删除括号。在SELECT列表中的括号内写入列列表将它们表示为ROW

CREATE TABLE joinedTables AS
Select 
  protein.accession, peptide_protein.mutation,
  peptide_protein.start_position, peptide_protein.end_position, 
  peptide.weight, peptide.sequence
from peptide
join peptide_protein on peptide_protein.peptide_id = peptide.peptide_id
join organism on organism.organism_id = peptide_protein.organism_id
join protein on peptide_protein.protein_id = protein.protein_id
order BY peptide.peptide_id;

或者将所有列转换为相同的数据类型，例如text，或者查看CREATE TYPE。