Postgres equivalent to MySQL’s \G?

I’m not familiar enough with MySQL to know what the \G option does, but based on the documentation it looks like the psql \x option might do what you want.

It’s a toggle, though, so you do it before you submit the query.

\x
select * from sometable;

Related Posts:

  1. Simple Random Samples from a Sql database
  2. Is there an equivalent of MySQL’s SHOW CREATE TABLE in Postgres?
  3. Postgres equivalent to MySQL’s \G?
  4. Postgres equivalent to MySQL’s \G?
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. How to use mysqli_query() in PHP?
  7. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  8. MySQL Error “Operand should contain 1 column”
  9. How to use MySQL DECIMAL?
  10. Access denied for user ‘root@localhost’ (using password:NO)
  11. MySQL ERROR 1290 (HY000) –secure-file-priv option
  12. MySQL server startup error ‘The server quit without updating PID file’
  13. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  14. How do I quickly rename a MySQL database (change schema name)?
  15. What does SQL Select symbol || mean?
  16. Duplicating a MySQL table, indices, and data
  17. mysql Foreign key constraint is incorrectly formed error
  18. SELECT * FROM multiple tables. MySQL
  19. MySQL error code: 1175 during UPDATE in MySQL Workbench
  20. mysql: SOURCE error 2?
  21. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  22. MySQL foreach loop
  23. How to find MySQL process list and to kill those processes?
  24. MySQL IF NOT NULL, then display 1, else display 0
  25. MySQL Server on MAMP-Windows Will Not Start
  26. SQL statement not working – “Operand type clash: date is incompatible with int’
  27. MySQL Calculate Percentage
  28. Repair all tables in one go
  29. Get the new record primary key ID from MySQL insert query?
  30. How can I rebuild indexes and update stats in MySQL innoDB?
  31. How to change collation of database, table, column?
  32. Failed building wheel for mysql-python
  33. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  34. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  35. Remove Primary Key in MySQL
  36. How to get the max of two values in MySQL?
  37. There can be only one auto column
  38. mysql: connection refused when trying to connect to localhost using remote IP
  39. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  40. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  41. What’s a good strategy for planning WordPress DB growth?
  42. Complex meta query with 3 keys
  43. How to log mysql errors from wordpress core?
  44. wpdb Custom Meta Data with 2 conditions
  45. query to create woocommerce products from images
  46. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  47. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  48. Configure WordPress to connect to Mysql DB using SSH tunneling
  49. How can I make wordpress suppress mysql errors?
  50. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  51. Rewrite database urls
  52. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  53. Migrating from Existing MySQL Setup to WordPress
  54. Connect another DB and fetch records from some tables
  55. How to split the a table in database?
  56. Error: MySQL shutdown unexpectedly [closed]
  57. How do I join a $wpdb query with user meta using default value if not exist?
  58. mySQL statment count of post in each category and sub category
  59. Paypal Post IPN handeling nightmare
  60. Database Structure on Different Servers
  61. Is there a page length limit?
  62. WordPress tables and aliases?
  63. What’s the sql for this condition?
  64. Create a form with custom autocomplete address field and CSV import values
  65. WordPress insert query is not working : Showing no Error
  66. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  67. Copy usermeta value where ID matches in the same table
  68. Some Post Content Does Not Show Up In DB Search
  69. How can I write a formal sql query to get data from a custom table
  70. How to insert dash (-) into database using wpdb and new_to_publish hook?
  71. MySQL: How to change url in posts from xxx.com to yyy.org?
  72. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  73. How can I view my site directly from WordPress dashboard?
  74. Button writing to MYSQL database
  75. (WP List Table) How to sort by SKU and Custom Fields?
  76. Word Press and database from another server sync
  77. MySQL ‘duplicate entry’ error
  78. User set date and time from frontend doesn’t get stored into database
  79. get posts whether meta_key exists or not
  80. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  81. How to bulk delete a certain part of all wordpress posts
  82. When I add metadata, metavalue length is added in to the value in some cases
  83. Changes not being reflected on new server
  84. WordPress Dutch characters encoding problem
  85. How to show result of sql query in a page?
  86. update_option returns false in AJAX, how to debug?
  87. WordPress database error Duplicate entry for key ‘slug’
  88. Select latest 2 articles, but only from given category
  89. CONCAT_WS in custom sql query
  90. MySQL – How to combine data from two tables into one?
  91. Ordering topics by most replies in X days using MYSQL statement
  92. Stop my loop to register data twice
  93. `#1215 – Cannot add foreign key constraint
  94. How to restore: Database intact but folders deleted
  95. XML RPC post produces immediate revision with odd post_date_gmt
  96. Woocommerce: Grab total revenue of a product over all orders
  97. Running WordPress from MySQL Cluster with HAPRoxy
  98. SQL command to export post_content from wp_posts using phpMyAdmin
  99. SQL Database Lost
  100. Possible SQL injection. How to locate and fix?

Leave a Comment