建立invoices表格,並匯入invoices.csv檔

[roberthsu2003]

• 下載csv
• 建立表格
• 匯入資料

[roberthsu2003]

CREATE TABLE IF NOT EXISTS city(
    id SERIAL,
    name VARCHAR(30),
    population INT,
    PRIMARY KEY(id)
);

SELECT *
FROM city;

[CNDING0618]

CREATE TABLE IF NOT EXISTS city(
    id SERIAL,
    name VARCHAR(100),
    population INT,
    PRIMARY KEY(id) 
);

SELECT *
FROM city;

DROP TABLE artists;

[Jerrywen1023]

CREATE TABLE IF NOT EXISTS city(
    id SERIAL,
    name VARCHAR(30),
    population INT,
    PRIMARY KEY (id)    
);

SELECT *
FROM city

[linnea07]

CREATE TABLE IF NOT EXISTS city(
id SERIAL,
name VARCHAR(30),
population INT,
PRIMARY KEY(id)
);

SELECT *
FROM city;``

[rebecca20140214]

CREATE TABLE IF NOT EXISTS invoices(
    invoiceid SERIAL ,
    customerid  int,
    invoicedate  timestamp,
    billingaddress  varchar(200),
    billingcity     varchar(200),
    billingstate     varchar(200),
    billingcountry   varchar(200),
    billingpostalcode    varchar(200),
    total  float,
    PRIMARY KEY(invoiceid)
);

[ke60030]

CREATE TABLE IF NOT EXISTS city( id SERIAL, name VARCHAR(30), popular INT, PRIMARY KEY (id) );

SELECT * FROM city;

[Rachell0224]

CREATE TABLE IF NOT EXISTS invoices(
    InvoiceId SERIAL PRIMARY KEY,
    CustomerId INT NOT NULL,
    InvoiceDate TIMESTAMP,
    BillingAddress VARCHAR,
    BillingCity VARCHAR(20),
    BillingState VARCHAR(10),
    BillingCountry VARCHAR(20),
    BillingPostCode VARCHAR(10),
    Total FLOAT8
);

SELECT * FROM invoices;

[LeeCiacia]

CREATE TABLE IF NOT EXISTS city( id SERIAL, name VARCHAR(30), popular INT, PRIMARY KEY (id) );

SELECT * FROM city;

[xbroth14]

CREATE TABLE IF NOT EXISTS  invoices
(
      invoiceid            SERIAL  PRIMARY KEY
    , customerid           INT
    , invoicedate          TIMESTAMP
    , billingaddress       VARCHAR(200)
    , billingcity          VARCHAR(200)
    , billingstate         VARCHAR(200)
    , billingcountry       VARCHAR(200)
    , billingpostalcode    VARCHAR(200)
    , total                FLOAT
);

SELECT  * FROM invoices  limit 100 ;

[xox723]

CREATE TABLE IF NOT EXISTS invoices(
id SERIAL PRIMARY KEY,
customerId INT,
date DATE,
address VARCHAR(100),
city VARCHAR(40),
state VARCHAR(20),
country VARCHAR(20),
postalcode VARCHAR(20),
total REAL
);

DROP TABLE invoices;
SELECT *FROM invoices;

[emilychiu527]

CREATE TABLE IF NOT EXISTS invoices(
    invoiceid SERIAL PRIMARY KEY,
    customerid int not null,
    invoicedate TIMESTAMP,
    billingaddress VARCHAR(100),
    billingcity VARCHAR(100),
    billingstate VARCHAR(100),
    billingcountry VARCHAR(100),
    billingpostalcode VARCHAR(100),
    total FLOAT(8)
);

SELECT *
FROM invoices

DROP TABLE invoices

[jackalcha]

CREATE TABLE IF NOT EXISTS invoices(
    id SERIAL PRIMARY KEY,
    Customerid INT,
    InvoiceDate DATE,
    Address VARCHAR,
    City VARCHAR(20),
    Sate VARCHAR(10),
    Country VARCHAR(20),
    PostalCode VARCHAR(20),
    Total REAL
);

SELECT * FROM invoices;

[chaoweichen]

CREATE TABLE public."invoicesTable"
(
    "invoiceId" serial NOT NULL,
    "customerId" integer NOT NULL,
    "invoiceDate" date,
    "billingAddress" character varying,
    "billingCity" character varying,
    "billingState" character varying,
    "billingCountry" character varying,
    "billingPostalCode" character varying,
    total real,
    PRIMARY KEY ("invoiceId")
);

ALTER TABLE IF EXISTS public."invoicesTable"
    OWNER to mypostgresql_dsaz_user;

SELECT * FROM public."invoicesTable"

[lingemily]

CREATE TABLE IF NOT EXISTS invoices(
    InvoiceId SERIAL,
    CustomerId INT,
    InvoiceDate TIMESTAMP,
    BillingAddress VARCHAR,
    BillingCity VARCHAR,
    BillingState VARCHAR,
    BillingCountry VARCHAR,
    BillingPostalCode VARCHAR,
    Total real,
    PRIMARY KEY(InvoiceId)
);

[chianning]

CREATE TABLE IF NOT EXISTS invoices( id SERIAL PRIMARY KEY, CustomerId INT, InvoiceDate DATE, BillingAddress VARCHAR(100), BillingCity VARCHAR(20), BillingState VARCHAR(20), BillingCountry VARCHAR(20), BillingPostalCode VARCHAR(20), Total real );

SELECT * FROM invoices;

DROP TABLE invoices;

[ke60030]

CREATE TABLE IF NOT EXISTS invoices(
    InvoiceId SERIAL,
    CustomerId INT,
    InvoiceDate TIMESTAMP,
    BillingAddress VARCHAR(200),
    BillingCity VARCHAR(100),
    BillingState VARCHAR(20),
    BillingCountry VARCHAR(100),
    BillingPostalCode VARCHAR(50),
    Total FLOAT,
    PRIMARY KEY(InvoiceId)
);

[Alice6520]

DROP TABLE invoices;
CREATE TABLE IF NOT EXISTS invoices(
id SERIAL PRIMARY KEY,
customerId INT,
date DATE,
address VARCHAR(100),
city VARCHAR(40),
state VARCHAR(20),
country VARCHAR(20),
postalcode VARCHAR(20),
total REAL
);

SELECT *
FROM invoices;``

[SandyYCH]

CREATE TABLE IF NOT EXISTS invoices(
 InvoiceId SERIAL PRIMARY KEY,
 CustomerId INT,
 InvoiceDate DATE,
 BillingAddress VARCHAR(100),
 BillingCity VARCHAR(20),
 BillingState VARCHAR(10),
 BillingCountry VARCHAR(20),
 BillingPostalCode VARCHAR(20),
 Total real
);

DROP TABLE invoices

SELECT *
From invoices;