[GENERAL] How to turn off DEBUG statements from psql commends

We are using PostgreSQL 9.3. Something seems to have changed with our psql command-line output since we first installed it. When I run commands at my plsql prompt, I am getting a lot of debug statements which I was not getting before. I am just trying to find out how to tell psql not to display

Re: [GENERAL] How to turn off DEBUG statements from psql commends

Thanks for all the replies. They were all right on. For some unknown reason, the client_min_messages was set to DEBUG5. Not sure how this happened but with your help, I now know how to get it back to where it was. Thanks again for all the quick feedback. - Peter -- View this message in

[GENERAL] How to list and describe tables in psql???

I am using PostgreSQL 9.1 and have boon looking for psql commands to list all tables in the current database as well as how to describe a given table. I have come across some info on the web (older mostly) that lists commands like \d, \dt, or \d+ tablename but I get results like no relations

Re: [GENERAL] How to list and describe tables in psql???

Thanks for the responses. I found that I was using an older version of psql (one that got installed when I installed Cygwin on my windows box. I changed it so now the \d+ gives me the description but \d and \dt still gives me No relations found so I must be using those incorrectly. Thanks

[GENERAL] How to list current user and database in PSQL

After logging into the PSQL Shell Script as a particular user and database, I want to display who my current user is and what database I am in as I may have forgotten who I am logged in as in order to make sure any commands are going to the right place. In Oracle's SQLPlus you can do something

Re: [GENERAL] How to list current user and database in PSQL

Excellent. That works. Many thanks! -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-list-current-user-and-database-in-PSQL-tp5784928p5784932.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list

[GENERAL] Format of Pioint datatype.... lat/long or long/lat??

PostgreSQL has a geometric data type of point. The format is listed as (x, y) but I am not sure if the X is to represent latitude or longitude. I have seen different systems that us X for either. Typically, coordinates should be read as lat/long but I have seen the opposite as well. An example

Re: [GENERAL] Format of Pioint datatype.... lat/long or long/lat??

Adrian - Thanks for the reply. The example was from http://www.postgresql.org/docs/9.1/static/tutorial-populate.html with the example of: INSERT INTO cities VALUES ('San Francisco', '(-194.0, 53.0)'); That is not a valid coordinate but it is clear that they are trying to declare it as longitude

Re: [GENERAL] Format of Pioint datatype.... lat/long or long/lat??

John - Appreciate the response. The reason why I asked this question is specifically for operations within PostGIS that will utilize the point values and so it is pretty important that the point values are entered correctly. Your description of X representing east/west and Y representing

Re: [GENERAL] Format of Pioint datatype.... lat/long or long/lat??

Perfect. That answers it. Thanks for providing that link. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Format-of-Pioint-datatype-lat-long-or-long-lat-tp5784939p5784960.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via