We will switch the output format by using ‘\a’ command. The command ‘\a’ is used to switch the output format from aligned to the non-aligned column and vice-versa. Command to switch output format from aligned to the non-aligned column and vice-versa Illustrate the result of the step by using the following snapshot.ġ8. Now we will modify the SQL query in a text editor and then we will close the text editor. We can edit that in the query in a text editor and can run it again. The ‘\e’ command used to open the recently executed SQL query in a text editor. Command to use the psql with the text editor The ‘\g’ command used to execute the previous command.ġ7. The ‘\timing’ command used to get the execution time of the SQL query in the PostgreSQL.ġ6. Command to get the execution time of SQL query Illustrate the result of the command by using the following snapshot.ġ5. If we want to have detailed information about any statement then we can use this command. The ‘\h’ command used to list all SQL commands in the PostgreSQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |