- Home
- »
Backing up and Restoring the PostgreSQL Cluster
Like with any other database, we should be taking regular dumps of backup of the database for recovery, migration, or any other purposes. There are three fundamentally different approaches to. read more…
Continue Reading
Extracting DDL of Objects
There are many methods to get the DDL of the objects. Using PostgreSQL executable pg_dump The utility pg_dump is used to dump the DDL and/or data of the schema and. read more…
Continue Reading
Viewing Metadata
PostgreSQL database provides two kinds of repositories or set of tables/views etc which you can query to get the information about the databases, transactions, tables, views, triggers, functions, all types. read more…
Continue Reading
Creating Trigger Functions
PL/pgSQL can be used to define trigger functions on data changes or database events. A trigger function is created with the CREATE FUNCTION command, declaring it as a function with no arguments and. read more…
Continue Reading
Creating Procedures
A procedure is a program that does some processing but doesn’t return a result. They are called using CALL command. A procedure is always defined in SQL standards. CREATE PROCEDURE creates. read more…
Continue Reading
Creating Functions
A function is a program that does some processing and then returns a result. They are called using SELECT SQL statement. A procedure can be defined in SQL or PGSQL. read more…
Continue Reading
Creating Views
CREATE VIEW defines a view of a query. The view is not physically materialized. Instead, the query is run every time the view is referenced in a query. Views can be. read more…
Continue Reading
Creating Tables
PostgreSQL support all standard objects like table, view, materialized views, types, sequences, triggers, functions, etc. Let’s take a look at these ones by one. Creating tables Tables are used to. read more…
Continue Reading
Creating Schemas
A schema is a namespace within a database. There is a default available schema name in each database, called as public. All objects created without any prefix to the object. read more…
Continue Reading