php - 用php加入postgres上的表

Question

我对postgresql数据库还是个新手，不懂是和mysql比较。如何在 postgresql 中组合 3 个表，

table1 = field_data_field_smcc_id

table2 = field_data_field_source_isolation

table3 = field_data_field_organism

<?php

$connectString = 'host=' . $host . ' dbname=' . $database . 
    ' user=' . $user . ' password=' . $password;


$link = pg_connect ($connectString);
if (!$link)
{
    die('Error: Could not connect: ' . pg_last_error());
}

$query = 'select * from field_data_field_smcc_id';
$result = pg_query($query);


?>

Answer 1

看这个link .我希望能得到您的答复。