Re: [GENERAL] Format

På mandag 28. september 2015 kl. 14:45:00, skrev Ramesh T < rameshparnandit...@gmail.com >: Hi All,           How to change sql format to look beautiful and understandable using pgadmin3 or else ther tools for postgres.   any help appreciated..   Use IntelliJ

Re: [GENERAL] Format

On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T wrote: > in my mind to be beautiful ,avoid confusion to understand sql query code > > like > > select abcd,cde,rfg,count(*),bcd,cde,rfg,count(*),bcd,cde,rfg,count(*) ; > > if some one written, then newer or code reader

Re: [GENERAL] Format

On 09/29/2015 06:13 AM, Ramesh T wrote: On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T > wrote: in my mind to be beautiful ,avoid confusion to understand sql query code like select

Re: [GENERAL] Format

Nice, thank you. On Tue, Sep 29, 2015 at 11:16 PM, Adrian Klaver wrote: > On 09/29/2015 06:13 AM, Ramesh T wrote: > >> >> >> On Tue, Sep 29, 2015 at 6:43 PM, Ramesh T > > wrote: >> >> in my mind

[GENERAL] Format

Hi All, How to change sql format to look beautiful and understandable using pgadmin3 or else ther tools for postgres. any help appreciated..

Re: [GENERAL] Format

On Mon, Sep 28, 2015 at 1:59 PM, Igor Neyman wrote: > Hi All, > > How to change sql format to look beautiful and understandable > using pgadmin3 or else ther tools for postgres. > > > > any help appreciated.. > > > > > > Are you looking for SQL editor? > > If

Re: [GENERAL] Format

CREATE FUNCTION CREATE VIEW As yes, I am being mostly serious - though I have been pondering seeing what tools can do as opposed to the manual formatting I've been performing. Even a basic linter would be helpful... The big problem is you need to define what it means to be beautiful.

Re: [GENERAL] Format

From: David G. Johnston [mailto:david.g.johns...@gmail.com] Sent: Monday, September 28, 2015 3:14 PM To: Igor Neyman <iney...@perceptron.com> Cc: Ramesh T <rameshparnandit...@gmail.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] Format On Mon, Sep 28, 2015 at 1:59 PM,

Re: [GENERAL] Format

Hi All, How to change sql format to look beautiful and understandable using pgadmin3 or else ther tools for postgres. any help appreciated.. Are you looking for SQL editor? If that’s the case, take a look at contexteditor.org Regards, Igor Neyman

Re: [GENERAL] Format

> > > Not only, there is little of formatting, like TABs. > > But, even highlighting helps. > > > ​Since pgAdminIII does highlighting I figured the OP wanted something more...I know what I am looking is more than just highlighting. David J. ​

[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??

On 12/31/2013 12:45 PM, peterlen wrote: 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

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

On 12/31/2013 12:45 PM, peterlen wrote: 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

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??

On 12/31/2013 01:09 PM, John R Pierce wrote: On 12/31/2013 12:45 PM, peterlen wrote: 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,

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

On 12/31/2013 02:16 PM, peterlen wrote: 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

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

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

On 12/31/2013 2:34 PM, Adrian Klaver wrote: point is just x,y, it doesn't understand the spherical lat/long math (unless you install PostGIS and use its Geometry types which are fully aware of spherical coords), that said, Latitude is generally used as X (left/right, aka east/west), while

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

On 12/31/2013 03:06 PM, John R Pierce wrote: On 12/31/2013 2:34 PM, Adrian Klaver wrote: point is just x,y, it doesn't understand the spherical lat/long math (unless you install PostGIS and use its Geometry types which are fully aware of spherical coords), that said, Latitude is generally used

[GENERAL] Format string for ISO-8601 date and time

Hi, Is there a format string for to_char(timestamptz, text) that would output a timestamp in full ISO-8601 format? That is, something like 1977-04-22T01:00:00-05:00 I can't find a way to extract the offset against GMT from the docs here:

Re: [GENERAL] Format string for ISO-8601 date and time

Hello 2009/2/26 Daniel Verite dan...@manitou-mail.org: Hi, Is there a format string for to_char(timestamptz, text) that would output a timestamp in full ISO-8601 format? That is, something like 1977-04-22T01:00:00-05:00 I can't find a way to extract the offset against GMT from the docs

Re: [GENERAL] Format string for ISO-8601 date and time

On Thu, Feb 26, 2009 at 10:50:18AM +0100, Daniel Verite wrote: Is there a format string for to_char(timestamptz, text) that would output a timestamp in full ISO-8601 format? That is, something like 1977-04-22T01:00:00-05:00 If I'm understanding correctly, that's a bit awkward to do. PG only

Re: [GENERAL] Format string for ISO-8601 date and time

Pavel Stehule wrote: Is there a format string for to_char(timestamptz, text) that would output a timestamp in full ISO-8601 format? That is, something like 1977-04-22T01:00:00-05:00 I can't find a way to extract the offset against GMT from the docs here:

Re: [GENERAL] Format string for ISO-8601 date and time

Sam Mason wrote: 1) values of type timestamp with time zone are always converted to UTC (either using the timezone specified or using the session's current timezone value) and then when they're sent back to the value is then corrected to the session's timezone (or an explicit

[GENERAL] Format Float numbers

Hi, I want format a column in select result: 1.1 = 1.10 Any idea? Thanks! Fernando Abraços, Fernando Abra sua conta no Yahoo! Mail, o único sem limite de espaço para armazenamento! http://br.mail.yahoo.com/ ---(end of broadcast)---

Re: [GENERAL] Format Float numbers

am Thu, dem 10.01.2008, um 10:03:05 -0300 mailte Fernando Xavier folgendes: Hi, I want format a column in select result: 1.1 = 1.10 Any idea? Yes. You can use to_char() or a CAST like test=*# select 1.1::numeric(10,2); numeric - 1.10 (1 row) Andreas -- Andreas

Re: [GENERAL] Format Float numbers

I want format a column in select result: 1.1 = 1.10 Any idea? Try the to_date() function like SELECT to_char(1.1, '0.99'); Yours, Laurenz Albe ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

[GENERAL] Format of BOOLEAN

Hello When I SELECT a row with a BOOLEAN in it I get either 't' or 'f'. But when I use this same value in the WHERE condition I get an error, because PostgreSQL demands either 'true' or 'false'. Example: testdb=# create table testtable (acolumn BOOLEAN); CREATE testdb=# INSERT INTO testtable

RE: [GENERAL] Format of BOOLEAN

-Message d'origine- De: Lehmeier, Michael [SMTP:[EMAIL PROTECTED]] Date: jeudi 7 juin 2001 18:06 Objet:[GENERAL] Format of BOOLEAN testdb=# SELECT * FROM testtable WHERE acolumn = t; ERROR: Attribute 't' not found testdb=# SELECT * FROM testtable WHERE acolumn = 't

Re: [GENERAL] Format of BOOLEAN

On Thu, 7 Jun 2001, Lehmeier, Michael wrote: Hello When I SELECT a row with a BOOLEAN in it I get either 't' or 'f'. But when I use this same value in the WHERE condition I get an error, because PostgreSQL demands either 'true' or 'false'. Example: testdb=# create table testtable

[GENERAL] Format of timestamp field

Hi, I used PostgreSQL 6.53 and I used tables with timestamps fields. When I read the value of a Timestamp field in a C program, i received a string of this format : 2001-04-08 12:54:09-0 Can someone give me some explanation about the meaning of the two last characters ? Thanks Natacha Joseph

[GENERAL] format of blobs ? backup blobs ?

When upgrading from 6.5 to 7.0 we backuped all data with pg_dump and so we lost our blobs. I just have the xinv and xinx-files from a file-backup. The blobs are stored in the xinvx-files, but there is a long leading header. Can anyone point me to the exact format of this files, so I can

[GENERAL] Format of PgDatabase::PgDatabase(char *conn)

Hello all, I am using libpq++, and I cannot find the format for the connect string passed as parameter to the PgDatabase constructor. Right now, I am forced to use environment variables. Can anyone educate me? Thanks, Don Dade __ Get Your