I am hoping to get some clarification on timestamp with time zone.
My understanding is that timestamp with time zone stores data in UTC
but displays it in your time zone. Does this also work on queries? If
I query between noon and 2:00 PM on some date in time zone XYZ does pg
translate the query
On 2021-09-20 13:37:52 -0400, Abhay Gupta wrote:
> Yes, Azure postgresql has a private endpoint attached to it so it is going
> through a private link. Also the server has 2 vcore and 5gb. Since currently
> we
> are in development phase there is no load on the server at all. No encryption
> and in
On 9/20/21 10:37 AM, Abhay Gupta wrote:
Hello Tom
Thanks for taking time in looking into this for us. Apologies for not
providing any required data.
Yes, Azure postgresql has a private endpoint attached to it so it is
going through a private link. Also the server has 2 vcore and 5gb. Since
Hello Tom
Thanks for taking time in looking into this for us. Apologies for not
providing any required data.
Yes, Azure postgresql has a private endpoint attached to it so it is going
through a private link. Also the server has 2 vcore and 5gb. Since
currently we are in development phase there is
Abhay Gupta writes:
> we are noticing the connection establishment is taking around 200-300 ms.
Not sure whether that's out of line or not, since you've provided
no background data (e.g. is the connection across a network link?
how busy is the server? what encryption and authentication are
you us
This is not a Postgres issue. Please reach out to the Azure team.
>
Hi
we are writing a python(3.9) azure function hosted on linux which is
connecting to azure postgresql 11. We are using psycopg2 to connect the
azure function to postgresql.
we are noticing the connection establishment is taking around 200-300 ms.
Below is the statment.
conn=psycopg2.connect(con
On Mon, Sep 20, 2021 at 3:18 PM Laurenz Albe wrote:
>
> On Sun, 2021-09-19 at 10:28 +, Niels Jespersen wrote:
> > We are often using the oracle_fdw to transfer data between Postgres
> > (version 11+) and Oracle (version 18+). It works great.
> >
> > However I have a task at hand that requires
On Sun, 2021-09-19 at 10:28 +, Niels Jespersen wrote:
> We are often using the oracle_fdw to transfer data between Postgres (version
> 11+) and Oracle (version 18+). It works great.
>
> However I have a task at hand that requires inserting a few billion rows in
> an Oracle table from a Post
On 9/20/21 12:52 PM, rami...@gmail.com wrote:
Hello Julien,
On 9/17/21 4:00 PM, Julien Rouhaud wrote:
Hi,
On Fri, Sep 17, 2021 at 9:55 PM wrote:
I was wondering what I'm doing wrong. There are steps what I've tried:
CREATE TABLE api (
jdoc jsonb
);
INSERT INTO api (jdoc)
VALU
On Mon, Sep 20, 2021 at 12:52:54PM +0200, rami...@gmail.com wrote:
> Hello Julien,
>
> On 9/17/21 4:00 PM, Julien Rouhaud wrote:
> > Hi,
> >
> > On Fri, Sep 17, 2021 at 9:55 PM wrote:
> > > I was wondering what I'm doing wrong. There are steps what I've tried:
> > >
> > > CREATE TABLE api (
> >
Hi,
not much to add besides thanks to both Alice and Guillaume.
Best regards,
Anthony
On Fri, Sep 17, 2021 at 6:57 AM Stacey Haysler
wrote:
> The PostgreSQL Community Code of Conduct Committee has received a draft of
> the French translation of the Code of Conduct Policy updated August 18,
> 202
Hello Julien,
On 9/17/21 4:00 PM, Julien Rouhaud wrote:
Hi,
On Fri, Sep 17, 2021 at 9:55 PM wrote:
I was wondering what I'm doing wrong. There are steps what I've tried:
CREATE TABLE api (
jdoc jsonb
);
INSERT INTO api (jdoc)
VALUES ('{
"guid": "9c36adc1-7fb5-4d5b-83b4-903
13 matches
Mail list logo