But I cannot use PGAdmin one more second in my life. If only they could do that for the column names too.but it's not their fault we have our setup this way.Īlso, I readily admit that Postico isn't as powerful as others.
Positive on TablePlus is that they did recently add some nice things to the SQL Query like wrapping my camelcase table name in double quotes for me. In TablePlus I can Import/Export Delete/Truncate. They also provide detailed installation, configuration, and usage information for the Snowflake-provided clients (CLI, connectors, and drivers) that form the. In Postico I can right click a table name and Open contents/structure/ddl, Copy Name (really useful for those dumb tables we set up in camelCase in the migration from mysql to postgres.), delete, truncate, Analyze, Vacuum, Reindex, Import CSV, and Export Portico offers a wide variety of seafood species including an assortment of fresh, frozen and prepared products. I can't remember what ENUM values I can choose in one of my tables, so that can be cumbersome.ģ) Postico has DDL right at the bottom of the tableĤ) Table right click options. Operators focused on quality seafood with a respect for the environment trust Portico to deliver seafood sourced with integrity. You have to right click and click, the "SET NULL" option.Ģ) Postico gives me a toggle for ENUM types and Bool types.
It happens to me pretty often where I accidentally click the wrong NULL column to update, and when I click away it sets it to "EMPTY", but maybe the column type is a timestamp or something.so I get an invalid type error when I go to add the one I meant to change manually. TablePlus thinks that if I have clicked into a column, I MUST mean that I want an empty string. There are a couple quality of life things:ġ) Postico can infer that I mean NULL if I delete a column value.
This is specific to my workflow and my project. Well, I wouldn't say "better" just things I miss and notice that bug me about TablePlus.