table and column comment

Hi, Dave I'm using pgadmin2 to develope an apllication on postgreSQL server. Would you please advise if I want to use sql statements to retrieve or update table and column comment, what can I do? Thank you! jack

[pgadmin-support] Questions & suggestions

uot;schema". But why pgAdmin has the schema? Is there any information about it? Thank you very much! Jack ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[pgadmin-support] Numeric Problem

meric' and 'double precision'..." select itemNo, listprice from itmt_info where listprice > 50.99; And this one works. select itemNo, listprice from itmt_info where listprice > '50.99'; I think it could be psqlODBC's problem. Would you please check

[pgadmin-support] problem on view data

Hi, Using: pgAdmin II V1.4.12 When view data of table pg_index, it will close down pgAdmin automatically. Thank you very much ! Jack ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send

[pgadmin-support] question about connection settings

n't find such a connection settings which I can do "set seach_path". If I open an sql window to do it, the pgAdmin didn't get the search path. It seems every sql window has its own connection. Is that possible to let sql window use the same connection with the pgAdmin? Thank you jin advance! Jack

[pgadmin-support] Error Message

-- System Information -- Platform: Windows 2000 Version:5.0 Build: 2195 Service Pack 3 -- Application Information -- Name: pgAdmin II Version:1.5.60 Descripton: Name: pgSchema Version:1.5.60 Descripton

Re: [pgadmin-support] question about connection settings

the table exists immediately. Jack - Original Message - From: "Guillaume Lelarge" <[EMAIL PROTECTED]> To: "Dave Page" <[EMAIL PROTECTED]> Cc: "Jack" <[EMAIL PROTECTED]>; Sent: Wednesday, August 01, 2007 5:49 PM Subject: Re: [pgadmin-sup

[pgadmin-support] how to display long records.

Hi PG Support folks, I am using pgadmin3 1.14.3 on Linux. after laying out a record with a 2k byte field at the end of the row, the pgadmin doesnt want to show me the full record. how do i get to scroll to the far right to see the full row? TIA< jackc..

Re: [pgadmin-support] how to display long records.

I am wondering why no reply to this query? No one knows or its a well know limitation to the query tool? I find it hard to believe there is no way to display long string fields... I did set the string display option from 256 -> 1024, but no joy... Comments? TIZ... -- View this message in co

Re: [pgadmin-support] how to display long records.

doesnt want to show me the full record. > > > > how do i get to scroll to the far right to see the full row? > > > > You click on the right edge of the column and push it on the right. > Works for me. > > well, within the default query pane size, that doesn't do much, But! your suggestion led me

Re: [pgadmin-support] how to display long records.

ller so that you can drag the > column size more to see more visible data. If there are newlines in your > data, then you can drag the row down to see the whole string. > > Btw I didnt see this email in the group so I am replying to you personally > here. > > Thanks > CG >

Re: [pgadmin-support] pgAdmin Freezing Up (Possible Greenplum Client Conflict?)

repended psql location on my path (now /Library/PostgreSQL/9.4/bin/psql) and telling pgAdmin where to look for the psql bin within Preferences, the same issue persists. I've done some googling, but haven't come up with anything. I'm running out of ideas. Any help would be greatly

[pgadmin-support] A few issues with pgAdmin4 Query Tool

Not sure whether these issues are unique to the OS X version, but I tried it with Beta-1, Beta-3, and Beta-4 of pgAdmin4. 1) Copy and Paste can only be accessed via the context menu (when editing the query command). The icons are disabled and the usual shortcut keys (cmd-c, cmd-x, cmd-v) do no

[pgadmin-support] Unable to get pgAdmin4 to connect to local database

I successfully added a connection to my production server (in the AWS cloud), but am having a problem connecting to my local server. When I try to connect, I get the error message box entitled “timeout” with the text “Connection to server has been lost”. The server is indeed running (in fact, I

[pgadmin-support] pgAdmin 4 - Navigating by word not working

shortcut keys (shift-arrow to select, cmd-c/x/v for cut and paste, etc.) seem to work just fine. Is this an oversight or a limitation of your framework? Navigation/selection by word is an extremely useful feature. Jack -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make

[pgadmin-support] pgAdmin4 - Connection Lost

?” question, the entire program aborts. Thanks, Jack -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support

[pgadmin-support] pgAdmin4 - Can't resize query window result columns

Attachment available until Nov 27, 2016 Hi Folks, I’m using the Query Window on Mac OS X 10.12, and while I get the column resizing icon, I am not able to resize the columns. Attached is a screen recording of my attempt to do so. Click to Download

[pgadmin-support] Troubleshooting connection problems

I have a local database that I am unable to connect to with pgAdmin 4 version 1.1 (. No problem connecting to it with pgAdmin III version 1.20.0. Datbase version is 9.2.2.0. Error is “Connection to the server has been lost.” I verified that the connection properties are the same. What are the ne

[pgadmin-support] UI Odditiies in the Query Tool

Hi Dave, Two strange UI behaviors in the Query Tool on Mac OS X 10.12 in the desktop version: 1) You cannot scroll the results pane horizontally until you have scrolled it vertically. 2) Once you have scrolled the display horizontally and vertically, you cannot resize any columns. I get the r

[pgadmin-support] Suggestion regarding Auto-Save

where I left off. While this is an OS X concept, it would be a great thing for pgAdmin4 to do across all platforms. It would be a bonus if this worked even if the program bombed. There may be other windows where this would make sense as well, but I’m not aware of them. Thanks, Jack -- Sent via

Re: [pgadmin-support] Restoring Db

I feel like I need to add some perspective here. pgAdminIII is version 1.20, while pgAdmin4 is version 1.1. That means that pgAdminIII **should** be a much more mature product than pgAdmin4. pgAdminIII has limitations that could not be addressed without a total re-write, and is based on older te

Fwd: [pgadmin-support] Serious feedback and questions about the future of pgAdmin.

Hi, First, I appreciate your tone of constructive criticism — there has been way too much negative criticism on this topic. However, as another user who has his own experiences with pgAdmin4, I feel compelled to reply regarding some of your complaints — please see my comments below. I don’t