在 pgAdmin (PostgreSQL) 中查看数据的简便方法
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5892222/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Easy way to view data in pgAdmin (PostgreSQL)
提问by Hoàng Long
I have searched this problem for more than an hour without any clue. In Heidi SQL (for MySQL), I just need few clicks to open any table to view its data. But in pgAdmin, I must collapse many sub-folder to do that: database/Schemas/public/Tables/... and then I must right click on a table to "view data". It's 3 times slower.
我已经搜索了这个问题一个多小时没有任何线索。在 Heidi SQL（用于 MySQL）中，我只需点击几下即可打开任何表以查看其数据。但是在 pgAdmin 中，我必须折叠许多子文件夹才能做到这一点：database/Schemas/public/Tables/... 然后我必须右键单击一个表以“查看数据”。它慢了 3 倍。
I wonder if there is any easier way to look through PostgreSQL data? Or is there any other way for Postgres that allow me to make it faster?
我想知道是否有更简单的方法来查看 PostgreSQL 数据？或者 Postgres 有没有其他方法可以让我让它更快？
采纳答案by hsmiths
Go to the properties of your server and check the "restore env" checkbox. That option causes pgadmin to remember your navigation between sessions. It will take you right to the table you selected last time you used pgadmin.
转到服务器的属性并选中“恢复环境”复选框。该选项使 pgadmin 记住您在会话之间的导航。它会将您带到上次使用 pgadmin 时选择的表。
回答by newenglander
If you set up an ODBC connection to the database, you can access it in Microsoft Access. You can then add the tables you view most often (assuming they're not so many of them) and save them (linked rather than copied) for quick viewing and editing.
如果设置到数据库的 ODBC 连接，则可以在 Microsoft Access 中访问它。然后您可以添加您最常查看的表格（假设它们不是很多）并保存它们（链接而不是复制）以便快速查看和编辑。
