PostgreSQL – PRIVILEGES Whenever an object is created in a database, an owner is assigned to it. The owner is usually the one who executed the creation statement. For most kinds of objects, the initial state is that only the owner (or a superuser) can modify or delete the object. To allow other roles or […]
Category Archives: postgresql
PostgreSQL – DATE/TIME Functions and Operators We had discussed about the Date/Time data types in the chapter . Now, let us see the Date/Time operators and Functions. The following table lists the behaviors of the basic arithmetic operators − Operator Example Result + date ”2001-09-28” + integer ”7” date ”2001-10-05” + date ”2001-09-28” + interval […]
PostgreSQL – Functions PostgreSQL functions, also known as Stored Procedures, allow you to carry out operations that would normally take several queries and round trips in a single function within the database. Functions allow database reuse as other applications can interact directly with your stored procedures instead of a middle-tier or duplicating code. Functions can […]