Re: [GENERAL] Can we make regexp processing more friendly by recognizing "\r\n" as a "newline" for "^$" purposes?

2015-10-18 Thread Francisco Olarte
Hi David: On Sun, Oct 18, 2015 at 7:49 PM, David G. Johnston wrote: > Other implementation of regular expressions handle "newline" mechanics > related to "^" and "$" semantically instead of literally. By that I mean > that both "\r\n" and "\n" are considered "newlines" instead of just "\n". Whi

Re: [GENERAL] Version management for extensions

2015-10-18 Thread Jeff Janes
On Fri, Oct 9, 2015 at 1:36 AM, Albe Laurenz wrote: > Jeff Janes wrote: > > I am facing a scenario where I have different version of an extension, > say 1.0 and 2.0, which have > > some different functionality between them (so not merely a bug fix), so > people might want to continue > > to use 1

Re: [GENERAL] PSQL Tools

2015-10-18 Thread Melvin Davidson
PgAdmin works great on Windows and is also available for the Mac. You can find both versions here: http://www.pgadmin.org/download/windows.php or http://www.pgadmin.org/download/macosx.php On Sun, Oct 18, 2015 at 6:37 PM, Nicolas Paris wrote: > > > 2015-10-19 0:08 GMT+02:00 dinesh kumar : > >>

Re: [GENERAL] PSQL Tools

2015-10-18 Thread Nicolas Paris
2015-10-19 0:08 GMT+02:00 dinesh kumar : > On Sun, Oct 18, 2015 at 7:04 AM, wrote: > >> Hello >> >> Is anyone aware of any tools like TOAD that are available for Postgresql? >> >> > PgAdmin fits here. > > >> Regards >> >> John Wiencek >> > > > > -- > > Regards, > Dinesh > manojadinesh.blogspot.co

Re: [GENERAL] PSQL Tools

2015-10-18 Thread dinesh kumar
On Sun, Oct 18, 2015 at 7:04 AM, wrote: > Hello > > Is anyone aware of any tools like TOAD that are available for Postgresql? > > PgAdmin fits here. > Regards > > John Wiencek > -- Regards, Dinesh manojadinesh.blogspot.com

Re: [GENERAL] PSQL Tools

2015-10-18 Thread jwiencek3
windows or Mac OS - Original Message - From: "Melvin Davidson" To: jwienc...@comcast.net Cc: "Adrian Klaver" , pgsql-general@postgresql.org Sent: Sunday, October 18, 2015 9:55:26 AM Subject: Re: [GENERAL] PSQL Tools PgAdmin seems to fit those requirements. It's free.and available

[GENERAL] Can we make regexp processing more friendly by recognizing "\r\n" as a "newline" for "^$" purposes?

2015-10-18 Thread David G. Johnston
Other implementation of regular expressions handle "newline" mechanics related to "^" and "$" semantically instead of literally. By that I mean that both "\r\n" and "\n" are considered "newlines" instead of just "\n". If changing behavior is not desirable I would be content with another flag that

Re: [GENERAL] PSQL Tools

2015-10-18 Thread Thomas Kellerer
jwienc...@comcast.net schrieb am 18.10.2015 um 16:04: Is anyone aware of any tools like TOAD that are available for Postgresql? https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to y

Re: [GENERAL] PSQL Tools

2015-10-18 Thread Yves Dorfsman
On 2015-10-18 08:04, jwienc...@comcast.net wrote: > Hello > > Is anyone aware of any tools like TOAD that are available for Postgresql? DBeaver works will all kinds of databases, DB2, Sybase, Oracle, SQLite, MySQL and PostgreSQL. It's written in Java and runs anywhere a JVM will: http://dbeaver.

Re: [GENERAL] PSQL Tools

2015-10-18 Thread Adrian Klaver
On 10/18/2015 07:48 AM, jwienc...@comcast.net wrote: Hello I am looking for a tool like TOAD for DBA's. I would like something that can generate/extract DDL; report manage tablespace, create explain plans, create/mange users, synonyms, triggers, etc. Well psql can do that:): http://www.pos

Re: [GENERAL] PSQL Tools

2015-10-18 Thread Melvin Davidson
PgAdmin seems to fit those requirements. It's free.and available for multiple platforms. http://www.pgadmin.org/ What O/S do you wish to install on? On Sun, Oct 18, 2015 at 10:48 AM, wrote: > > Hello > > I am looking for a tool like TOAD for DBA's. I would like something that > can generat

Re: [GENERAL] PSQL Tools

2015-10-18 Thread jwiencek3
Hello I am looking for a tool like TOAD for DBA's. I would like something that can generate/extract DDL; report manage tablespace, create explain plans, create/mange users, synonyms, triggers, etc. regards John Wiencek - Original Message - From: "Adrian Klaver" To: jwienc...@c

Re: [GENERAL] PSQL Tools

2015-10-18 Thread Adrian Klaver
On 10/18/2015 07:04 AM, jwienc...@comcast.net wrote: Hello Is anyone aware of any tools like TOAD that are available for Postgresql? The universe of database management tools is large. In order to answer the above, what is is that you want to do? Regards John Wiencek -- Adrian Klaver

Re: [GENERAL] PSQL Tools

2015-10-18 Thread vincent
Op 18-10-2015 om 16:04 schreef jwienc...@comcast.net: Hello Is anyone aware of any tools like TOAD that are available for Postgresql? Regards John Wiencek There are several, I use EMS SQL-manager freeware version. The commecial version has more features, but the freeware version supports

[GENERAL] PSQL Tools

2015-10-18 Thread jwiencek3
Hello Is anyone aware of any tools like TOAD that are available for Postgresql? Regards John Wiencek

Re: [GENERAL] ID column naming convention

2015-10-18 Thread Karsten Hilbert
> > Here's a real live schema using (mostly) the above approach: > > > > http://www.gnumed.de/~ncq/gnumed/schema/gnumed_v20/ > > > > in case anyone is interested in taking a look. > > > > Karsten > > Apparently (according to your naming convention) several tables (such as > 'clin.substance_in