Create a table named CustomerInvoices
Following steps will help you create a table named CustomerInvoices with five columns (InvoiceID, CustomerName, InvoicePeriod, ProductName, and InvoiceValue).
You need to follow the procedure described below to create a database instance, create table, and copy sample data in it.
Following steps will help you create a table named CustomerInvoices with five columns (InvoiceID, CustomerName, InvoicePeriod, ProductName, and InvoiceValue).
You need to follow the procedure described below to create a database instance, create table, and copy sample data in it.
Run SQL Shell
Click PostgreSQL 9.3 -> SQL Shell (psql), from Programs menu of your Windows installation, to run SQL Shell for PostgreSQL server.
You
will see SQL Shell consol window. SQL Shell window will prompt you for
server location, database, port and username, press Enter for each
prompt.You will be logged to postgres database.
Create Database instance
Copy following SQL command in SQL shell to create a database instance.
-> CREATE DATABASE jasperdb1;
Copy following SQL command in SQL shell to create a database instance.
-> CREATE DATABASE jasperdb1;
Your jasperdb1 database instance will be created.
Now follow the steps in next section to copy data in the jasperdb1 database.
Now follow the steps in next section to copy data in the jasperdb1 database.
Comments
Post a Comment