#!/usr/bin/python3

import psycopg2

conn = psycopg2.connect(
  user="username",
  password="password",
  host="db_host",
  port="5433"
  dbname="db_name")

cursor = conn.cursor()
createSQL = "CREATE TABLE student(NAME TEXT, AGE INT);"
cursor.execute(createSQL)
conn.commit()
print("Table创建成功")

package main
import (
   "database/sql"
    "fmt"
    _ "github.com/lib/pq"
)
func main() {
    psqlInfo := fmt.Sprintf("host=%s port=%d user=%s "+
    "password=%s dbname=%s sslmode=disable",
    host, port, user, password, dbname)
    db, _ := sql.Open("postgres", psqlInfo)
    defer db.Close()
    if _, e := db.Exec(`CREATE Table student (name text, age int);`); e == nil {
        fmt.Println("Table创建成功")
   }
}

package com.memfire.sample.apps;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class MFSample {
  public static void main(String[] args) {
    Class.forName("org.postgresql.Driver");
    Connection connection = null;
    connection = DriverManager.getConnection("memfiredb_connect_string")
    String createStmt =
      "CREATE TABLE student (name text, age int);";
    connection.createStatement().execute(createStmt);
    connection.close();
}