Translate

Showing posts with label add column. Show all posts
Showing posts with label add column. Show all posts

Tuesday, October 29, 2024

How to Create Table in POSTGRESQL

Creating table in PostgreSQL is very much similar like MSSQL. Syntax is like below, 

 CREATE TABLE <TableName>
 (
    <column name1> <data type>,
    <column name2> <data type>,
    ...
);

Example: 
     CREATE TABLE Wings
         ( 
             WingID uuid primary key, 
             WingName VARCHAR(100), 
             IsActive boolean 
        );