Posts Tagged ‘PostgreSQL’

Difference between delete and truncate

Delete: Whenever we are using delete from tablename, then automatically deleted data internally stored in buffer. We can get it back by using rollback command.

emp table script PostgreSQL

Standard emp table script for PostgreSQL 1) Create table structure 2) Insert data into emp table

How to access the database in PostgreSQL

We can access the database using psql db_name. By default, we connect to postgres database. If we want to change the current database from psql shell, use \connect database_name k2schools-# \connect postgres WARNING: Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly. See psql reference page “Notes for […]

How to create database in PostgreSQL

Database is collection objects like tables, indexes, views, triggers, etc. Following article explains ‘How to create database in PostgreSQL’, Syntax ,Parameters and Examples. To create database in PostgreSQL, user must have CREATE Database permission or user must be superuser. By default, the new database will be created by cloning the PostgreSQL system database template1 Syntax: […]

How to connect to the PostgreSQL database server

After installation of PostgreSQL database server, we have to connect to the database to create database, tables, stored procedures,…..etc. In PostgreSQL Server, we can connect to the database server either using SQL shell(psql) or pgAdmin Tool(Graphical User Interface). Connect to the PostgreSQL database server using SQL Shell(psql) tool: 1. Launch the SQL shell(psql) as shown […]

PostgreSQL Installation on Windows

PostgreSQL is open source RDBMS. Please follow below steps to Install PostgreSQL on Linux. We are installing postgresql-9.4.8-1 on Redhat Windows. 1. Download from EnterpriseDB 2. Double click on the exe downloaded from EnterpriseDB to start the PostgreSQL installatiion.

Install PostgreSQL on Linux

PostgreSQL is open source RDBMS. Please follow below steps to Install PostgreSQL on Linux. We are installing on Redhat Linux. 1. Download from EnterpriseDB. 2. Copy the tar file and unzip it by running following commands. gunzip ppasmeta- tar xf ppasmeta-

nosql vs sql databases differences

Following are major differences between NoSql and Sql databases NoSQL Database SQL Databases Open Source databases Mixed(Open source and closed source) Different types including key-value stores, document databases, wide-column stores, and graph databases One type (SQL database) with minor variations Examples: MongoDB, HBase, Cassandra, Neo4j Oracle, PostgreSQL, MySQL, Microsoft SQL Server, Sybase

Powered by k2schools