xxxxxxxxxx
CREATE TABLE IF NOT EXISTS YourTableName (
column1 datatype,
column2 datatype,
);
xxxxxxxxxx
CREATE TABLE IF NOT EXISTS
> CREATE TABLE IF NOT EXISTS TEAMS
> (TEAMNO INTEGER NOT NULL PRIMARY KEY,
> EmployeeNO INTEGER NOT NULL,
> DIVISION CHAR(6) NOT NULL);
xxxxxxxxxx
CREATE TABLE IF NOT EXISTS Companies (
id int,
name varchar(50),
address text,
email varchar(50),
phone varchar(10)
);
xxxxxxxxxx
CREATE TABLE IF NOT EXISTS table_name (
column1 datatype1,
column2 datatype2,
);
xxxxxxxxxx
create table if not exists schema_uploadfile.tbl_uploadfile(
id serial primary key,
file_name varchar(255) unique,
file_type varchar(30),
grp_data bytea
);