w3resource logo


PostgreSQL Create Table

PostgreSQL Create Table

Secondary Nav

Create Table

This document discusses how to create a table in PostgreSQL using the command line, pgAdmin III and phppgAdmin. For ease of understanding, each process is complemented by screenshots taken while doing.

Create Table using command line in Linux

Start terminal and execute the following command :

sudo -u postgres psql postgres

This command will bring you to the PostgreSQL command prompt. Now, to create a table issue the following command.

CREATE TABLE emp_data (
name text,
age integer,
designation text,
salary integer
);

The above command will create a table called emp_data with four columns - name, age, designation and salary and their datatypes are text, integer, text and integer.

create table form command line

If you want to see whether the table is actually created, issue the following command.

\dt

This will show you the table you have created, as shown in the following image.

show table command line

To delete an existing table issue the following command.

DROP TABLE emp_data;

The above command deletes the emp_data table.

delete table command line

Create Table using pgAdmin III

Start pgAdmin III from Application > Programs > pgAdmin III if you are using Linux and All Programs > PostgreSQL 9.1 > pgAdmin III if you are using Windows. Then right click on your server on the right pane of your pgAdmin III window and click connect. Now your server is connected.

create table pgadmin step1

Now reach "tables" in pgAdmin III window, right click on "tables" and click on "New Table".

create table pgadmin step2

This will open a new window to create a New Table. Supply a name of your new table and then click on Columns.

create table pgadmin step3

Now in the columns window, you can add columns you want and their data types by clicking "Add" and clicking on "Ok" after you finish supplying a name and data type for each column.

create table pgadmin step4

After you finished creating a table, you can see the detail of the table as shown below.

create table pgadmin step6

To delete the table select the table, right-click and click on "Delete/Drop". When prompt, say "Yes".

delete table pgadmin

 

Create Table using phpPgAdmin

Login to phpPgAdmin and reach "Public" database. Now click on "Create table" in the right hand pane of the phpPgAdmin window.

create table phppgadmin

In the next window, supply name and number of columns you want to create and click "Next".

create table phppgadmin step2

In the next window, supply name of the column, data type and click "Create".

create table phppgadmin step3

If you have successfully created the table, you can see the table you have created as shown below.

create table phppgadmin step4

Note

There are other options or variables available while you create a table, like setting primary or foreign key. But for the sake simplicity, we kept those options out of the scope of this document. But we will discuss all those in detail while we progress.



Join our Question Answer community to learn and share your programming knowledge.

Solve these problems:

Java: How to convert a string to an integer in Java?

C#: Loops in c#

SQL: JOIN using more than 5 tables