Menu
I use PosgreSQL as database and PgAdmin as tool to manage it. When I write simple select (col is type of text and value of it is quite long, about 4k chars)
SELECT col FROM tab
I get this (there is about 250 chars before brackets):
abababababa(...)
but I inserted longer value. PgAdmin trim showed value and ends it with(...) string. How can I get whole content inside PgAdmin?
392
Select Database using pgAdmin You can also select the database and open SQL Query window in pgAdmin UI. Step 1: Select the database, by clicking on it. Now, click on the Tools drop down menu and click on Query Tool . Now, a new window appears with a connection make to the database you selected.
PostgreSQL SELECT statement syntax If you specify a list of columns, you need to place a comma ( , ) between two columns to separate them. If you want to select data from all the columns of the table, you can use an asterisk ( * ) shorthand instead of specifying all the column names.
Then either click the magnifying glass in the toolbar, or click Tools > Query Tool in the menu bar, to open the query window. 4) In the top left box of the query window, paste the script or query you received from our support department and then use the menu bar to click Query > Execute.
To view or modify data, right click on a table or view name in the Browser tree control. When the context menu opens, use the View/Edit Data menu to specify the number of rows you would like to display in the editor panel. To modify the content of a table, each row in the table must be uniquely identifiable.
Try set this value in PgAdmin config:
File > Options > Query Tool > Max. characters per column
Look on settings on this page
EDIT: For full column content you have to use -1, if left empty PgAdmin3 automatically replaces it with a 0 and nothing is shown but "...".
113
In PgAdmin.. If you want 'unlimited': File -> Options -> Query Tool -> Max. char. per column -> -1
45
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
