In our database, we want to use the Database to generate a new UUID, when we insert new records. As mentioned previously PostgreSQL doesn't include any UUID generation functions, therefore we have to add one of the extension such asuuid-ossporpgcrypto. This can be done by placing the fo...
Uuid_generate_v1 generates a UUID number by combining the computer’s Mac address, current timestamp, and any random number. We can generate a UUID number by using this function in PostgreSQL. To use this function, we need to create an extension of UUID-OSSP in PostgreSQL. Uuid_generate_v...
PostgreSQL is a powerful database that has been battle-tested in many applications. Laravel is a reliable and flexible PHP framework with great community support. Together, they enable PHP developers to deploy web applications quickly and cleanly. This quick tutorial will lay the groundwork for any...
how to formatting a number in mvc view How to generate a code for the email confirmation ( when user register into my site) How to generate a pdf from a List<> and export it to excel How to generate data to excel file and save to folder before client download using EPPlus in MVC...
HOW TO GET WEEK NUMBER IN THE PARTICULAR MONTH IN SSIS DERIVED COLUMN how to hand handled ssis timeout when running Execute sql task. How to have SSIS escape double quotes within a string in a CSV file destination which also uses double quotes as its string delimiter? How to ignore a tra...
Find the most recent PostgreSQL.msi in C:\ProgramData\Package Cache\ and remove it. This removes the service but no old local database data. This is needed to prevent issues on future upgrades of Environment. You can find the precise folder with this command depending...
On the target PostgreSQL database, run a query to generate DDL on the database tables’ foreign key constraints and save the output. You can find many sample queries online to do this. You should get a similar to the following. Doing this gives us the DDL to recreate the foreign key co...
-- PostgreSQL specific hack you can use to make -- really sure only one row ever exists CREATE UNIQUE INDEX there_can_be_only_one ON invoice_number( (1) ); -- Start the sequence so the first returned value is 1 INSERT INTO invoice_number(last_invoice_number) VALUES (0); ...
For example, you might need to determine how long it will take to generate 100 image thumbnails from disk or how much memory a data structure will take. The Powers of two table and Latency numbers every programmer should know are handy references....
When the script execution is complete, it mounts a disk with a volume 25 GB in size. This disk contains the necessary files to generate the dataset for loading the test data. You can check this by running the commanddf –h. When you clean up at the end of t...