When you are working with databases or web applications deleting records is one of the most common tasks, it can happen for various reasons and because it understand how to do it is essential.
In PostgreSQL deleting records is performed using the DELETE command syntax as shown below:
DELETE FROM [Table]
As a practical example we will delete all records from a table that stores the sales of a store.
DELETE FROM tbl_sales
With the above syntax all products will be deleted and this can be a problem since it does not always delete all records from a table of production is recommended, so it is important to use clause WHERE with the command.
DELETE FROM tbl_sales WHERE cod_sales = 1
In the example above only the record that has the code 1 is removed from the table.
Delete records is an action that needs to be done very carefully since deleted data can not be restored unless a backup is done and restored later.
Currently he is known as one of the most advanced free databases in the world, created in 1985 by Michael Stonebraker, it is in the version 9.0 released in 2010. The PostgreSQL Global Development Group works hard in the source code of the database to make it more complete.PostgreSQL has gained more space in the market for web development because of the large amount of resources it has, moreover, it is a free DBMS and this makes it extremely attractive for those who need to work with low-cost projects.
Who uses the PostgreSQL database in PHP projects successfully combine low production and maintenance cost, also it has many of the features that the databases offers thus making it a complete option.
But when you are developing a project, is essential to have a tool that can assist you. With Scriptcase you can easily connect to PostgreSQL database, all you need to inform to connect to the PostgreSQL is:
- Connection Name: It will help you identify the connection among the others.
- DBMS Driver: it Will show a list with all drivers available.
- Server/Host(Name or IP): The physical address from the database, it may be local on your machine, on your local network or remote in the cloud.
- Port: The port that you want to use to connect to your database.
- Username: Username for the user from the database.
- Password: The password from the previous selected username.
Once you connect Scriptcase with your database, it will read your tables and create applications based on the desired tables. Scriptcase will identify all special characteristics from your table, such as primary keys, foreign key, auto-increments, among others, and will show that at the application level. All the CRUD (Create, Read, Update and Delete) actions will be managed by the Scriptcase. On forms and reports all the navigation, searches and filters (Static or Dynamic) will be also handled by Scriptcase automatically.
Scriptcase support stored procedures and all SQL statements (joins, order by, group by, among others) of PostgreSQL, why lose time when you have Scriptcase to help you out?! Download it now and test it free for 20 days!