Seen the suggestions.
After decades of playing with the alternatives, I don't overthink it
anymore. Pretty much my lookup tables consist of an autogenerated primary
key (smallint or integer), a code (name?) and a description as default.
If there are a lot of tables fitting a common data format,
From: Tony Shelver
Date: Mon, 11 Mar 2024 at 12:24
Subject: Re: Performance (and general) considerations between views and
functions
To: Wiwwo Staff
On Mon, 11 Mar 2024 at 12:08, Wiwwo Staff wrote:
> Hi Community!
> I am in the process of re-writing SQLs in app code to a more D
Environment is Ubuntu 18.04, pgAdmin4.13 was loaded from the relevant
ubuntu repository.
This was working previously, changed in the last week. It could have been
after an install.
I get this message when running from the app icon.
If I run it from the command line in /usr/bin, I get the same err
the only way I could find after
>> accidentally detaching a pane.
>>
>> Cheers,
>> Dave
>>
>>
>> On Tue, Aug 20, 2019 at 1:52 PM Tony Shelver wrote:
>>
>>> Accidentally detached the result window in the Query tool, how do i get
>>> it back a
Accidentally detached the result window in the Query tool, how do i get it
back again so it's no longer floating?
I have used several other db editors, this is the first time I have seen
this 'feature'... Which I _really_ don't see a use for
Otherwise, finding rate of improvement on pgAdmin
On Tue, 6 Aug 2019 at 14:32, Ashesh Vashi
wrote:
> If you're running from the sql editor, then - you have either of the two
> options:
> Set search_path = 'teleon, public';
> CREATE TABLE...
>
> Or,
>
> Specify the schema in front of tge type.
>
> -- Thanks, Ashesh
>
>
> Will have a go at it. Ho
t; \dT geography
>
> --
>
> Thanks & Regards,
>
> Ashesh Vashi
> EnterpriseDB INDIA: Enterprise PostgreSQL Company
> <http://www.enterprisedb.com>
>
>
> *http://www.linkedin.com/in/asheshvashi*
> <http://www.linkedin.com/in/asheshvashi>
>
>
> On
On Tue, 6 Aug 2019 at 12:18, Ashesh Vashi
wrote:
> Can you please let me know the output of 'SHOW search_path' from the psql?
>
Ashesh, if I run SHOW search_path in psql, there is no output. Just
returns with the prompt.
PGadmin4.11
Ubuntu 18.04
Postgresql 11.4
I just tried to create the table below:
CREATE TABLE teleon.to_location (
locn_id serial NOT NULL,
geo_position geography(POINT, 4326) NOT NULL,
upd_time timestamp NOT NULL,
app_src_key char NOT NULL,
CONSTRAINT to_location_pk PRIMARY KEY (locn_id)
I got :
