We’ve used them in the past, but sparingly. Usually if the data is abstracted
nicely for loading into the DB, you can get away with most processes only
needing SQL, at least in our cases. There are obvious exceptions for things
like monitoring or logging.
Our use has been for running some set
>From here: https://www.postgresql.org/docs/9.2/app-psql.html
-F separator
--field-separator=separator
Use separator as the field separator for unaligned output. This is equivalent
to \pset fieldsep or \f.
Bobb
> -Original Message-
> From: Rich Shepard
> Sent: Monday, July 19, 20
All,
First, I AM an old-timer, and prefer the top posting for a number of reasons.
I’ve tried the Digest versions of lists in the past and they didn’t quite work
out (for me).
Top post, newest on top, older stuff indented, can be clipped wherever,
although I prefer to see everything if I need
Maybe check out using the UPPER/LOWER/INITCAP functions in the order by clause?
Bobb
> -Original Message-
> From: basti
> Sent: Thursday, March 18, 2021 9:40 AM
> To: pgsql-gene...@postgresql.org
> Subject: postgresql order lowercase before uppercase
>
> Think Before You Click: This
I manage database clusters where the number of databases is a reason not to do
logical replication based upgrades, where pg_upgrade is far preferred instead.
If this were to be the case, I would be very concerned that a bunch of things
would have to change:
1. Shared catalogs would have txid
AM
To: pgsql-general@lists.postgresql.org
Subject: RE: Enforcing uniqueness on [real estate/postal] addresses
Think Before You Click: This email originated outside our organization.
On Wed, 13 May 2020, Basques, Bob (CI-StPaul) wrote:
> Was wondering if you ever thought about binding the textual
I've been following this thread with some interest.
Was wondering if you ever thought about binding the textual address to a USNG
location. https://usngcenter.org/
You can easily add individual locations within something like a farm field with
as few as eight unique digits that would identify
laces.
> Not at My desk to try.
>
>>> On 10/28/19 8:00 AM, Basques, Bob (CI-StPaul) wrote:
>>> All,
>>>
>>> Take a look at the VI(m) editor. There is a Syntax mode for highlighting
>>> different file types, as well as tools for exporting t
As far using VIM (vs EMACS):
https://en.wikipedia.org/wiki/Editor_war
:c)
bobb
On Oct 28, 2019, at 8:33 AM, Rob Sargent
mailto:robjsarg...@gmail.com>> wrote:
Think Before You Click: This email originated outside our organization.
On Oct 28, 2019, at 7:00 AM, Basques, Bob (CI-
All,
Take a look at the VI(m) editor. There is a Syntax mode for highlighting
different file types, as well as tools for exporting the highlighted text to
HTML. I have yet to find a file type that it doesn’t already handle.
Works really slick.
bobb
> On Oct 27, 2019, at 5:21 PM, stan wro
David,
You should find a fit in here somewhere:
https://pgdash.io/blog/postgres-gui-tools.html
https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
Also, we’ve done some interesting things with building an interface inside of
LibreOffice as well. It’s still a separated appr
SELECT EXTRACT(EPOCH FROM age('2019-09-11 09:00:00','2019-09-09
11:00:00')::INTERVAL)/60;
A nice explanation and even a slick function are here:
https://stackoverflow.com/questions/3460805/postgresql-format-interval-as-minutes
bobb
On Sep 11, 2019, at 10:38 AM, David Gauthier
mailto:davegau
Hi Judith,
Might be more than you are looking for, but . . . We’ve done something like
this with a portable mapping system installed on a Raspberry Pi. Really!!, it
works with Postgres and a webserver to serve out a replicated open software
stack based mappint interface.
Our focus was on usin
All,
No Web driven, but . . . . we’ve had some success with using LibreOffice(calc)
as a frontend. Fairly easy to build forms, etc. Only limited experience so
far, but was able to build domain lists from SQL calls, for form pulldown
lists, etc.
bobb
> On Aug 8, 2019, at 2:10 PM, Rich Shep
I can second this as an option. We’ve done some editing with Libre office as
well in Postgres.
bobb
On Oct 31, 2018, at 5:01 AM, Tony Shelver
mailto:tshel...@gmail.com>> wrote:
For a quick and dirty data editor, LibreOffice Base seems to work fine.
On Tue, 30 Oct 2018 at 23:05, Tim Clarke
On Apr 27, 2018, at 10:46 AM, Guyren Howe
mailto:guy...@gmail.com>> wrote:
On Apr 27, 2018, at 8:45 , Basques, Bob (CI-StPaul)
mailto:bob.basq...@ci.stpaul.mn.us>> wrote:
Just chiming in . . . we’ve taken a somewhat different approach and actually
encourage our programmers
All,
Just chiming in . . . we’ve taken a somewhat different approach and actually
encourage our programmers to build out thier own DBs. We’re using Postgres to
aggregate many varied datasources into postgres as a cahing system, and then
develop against this aggregated data. Yes, we understan
What Tim said!! :c)
I think the bigger deal is setting a new message Subject at the approriate
point in a thread/conversation.
bobb
On Feb 16, 2018, at 2:23 PM, Tim Cross
mailto:theophil...@gmail.com>> wrote:
Thomas Kellerer mailto:spam_ea...@gmx.net>> writes:
Melvin Davidson schrieb am
All,
Not really an app, but we have a Apache script that logs all the activity to
our Postgres/PostGIS services and inserts the log entries directly into
Postgres. Works great for reporting our Postgres web traffic stuff. My dev
guy was skeptical about it being effective and not binding up at
Melvin,
Thanks for posting these. I haven’t even looked at them yet and just grabbed
them based on the names. :c)
On Feb 15, 2018, at 9:11 PM, Melvin Davidson
mailto:melvin6...@gmail.com>> wrote:
On Thu, Feb 15, 2018 at 9:22 PM, Tim Cross
mailto:theophil...@gmail.com>> wrote:
Hi All,
I
20 matches
Mail list logo
