Storing large object files into database is much interesting then saving path of files. Large object data like images, document can be save into database by two simple method: 1> Save images in base encoded form that i had explained in my earlier article PHP Encoding with base64 2> Use BYTEA Data type in Postgresql. […]
Dynamic table name in PostgreSQL trigger used as “TG_TABLE_NAME” “TG_TABLE_NAME” is a name of the table that caused the trigger invocation. Like If you want to copy data from one table to another on updating first table Then start using triggers Lets say you have table name “first_table” Create same table as log table to […]
This Tutorial introduces how to extract Information Schema in PostgreSQL with simple Sql queries. Information schema provides information about tables, columns, views, trigger, functions and sequences in a database. We extract these information from simple SQL queries, lets we have a well maintained database and below are simple Sql statements to get various information in […]