postgres crear tabla
-- Basic table creation
CREATE TABLE table_name(
column1 datatype,
column2 datatype,
column3 datatype,
.....
columnN datatype,
PRIMARY KEY( one or more columns )
);
crear tabla en postgresql
-- Example table
CREATE TABLE accounts (
user_id serial PRIMARY KEY,
username VARCHAR ( 50 ) UNIQUE NOT NULL,
password VARCHAR ( 50 ) NOT NULL,
email VARCHAR ( 255 ) UNIQUE NOT NULL,
created_on TIMESTAMP NOT NULL,
last_login TIMESTAMP
);
crear tabla postgresql
CREATE TABLE table_name (
column_name TYPE column_constraint,
table_constraint table_constraint
) INHERITS existing_table_name;
postgresql crear tabla como seleccionar
CREATE TABLE films_recent AS
SELECT * FROM films WHERE date_prod >= '2002-01-01';
mostrar crear tabla en postgresql
pg_dump -t 'schema-name.table-name' --schema-only database-name
postgre sql crear tabla
CREATE TABLE cities (
city_id serial PRIMARY KEY,
city_name VARCHAR (255) NOT NULL,
population INT NOT NULL CHECK (population >= 0)
);