Category: Database


Format Chilean Rut in Postgresql

Here is a very practical method to format Chilean Rut ( The only requirement is to have the following function previously.PadIndex Postgresql


PatIndex Postgresql

As you may already notice postgresql does not contain the function patidex, it is for this reason that we bring them to you next:

We hope its usefulness


First letter of each word in uppercase Postgresql

Unlike other database engines Postgresql provides us with the initcap() function to apply capital letter to our chains. Here is an example:

Result: Hello World I hope it’s usefull


Get data from a table in MySQL

In MYSQL there are several methods to know if a table exists or get information from the table directly from the SHEMA, one way is as follows: