On 17/09/18 13:31, vyshu Ysh wrote:
Hi,
I wanted to query from my c# application. Am using npgsql, is there any
parameter or api ?
select * from pg_stat_replication;
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
for professional programmers.)
What do you think?
Hi there,
You'll be interested to know that there is a mailing list specifically
for GUI development, though it's been quiet recently:
https://www.postgresql.org/list/pgsql-gui-dev
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
something open source.
I use Depesz Versioning[1] - simple concept and easy to use, and quite
sufficient for my (simple) needs.
Ray.
[1] https://www.depesz.com/2010/08/22/versioning
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
the quality of the Postgres code.
How? It will entrench women and fags in the Postgres community.
Is someone running unit tests on the CoC? :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
an issue, in my experience anyway. There might
be an occasional turn of phrase which I have to parse a bit, but that's
about it. :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
in there as well:
insert into my_table(name, age)
select 'value 1', 'value 2'
where not exists (
.
);
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
as an argument - I don't think that this is possible with psql.
Details here:
https://www.postgresql.org/docs/10/static/app-psql.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
. It wasn't obvious on the
website either, until I saw the line about .Net.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
So, I take the documentation would be outdated?
But why do I get following error?
ERROR: function gen_random_uuid() does not exist.
create table ENTITY (ID uuid not null default gen_random_uuid());
Only a guess, but maybe you need to install the extension first? -
create extension ;
Ray.
--
Raymo
and no rows will be inserted. Does it realizable or Should I
create a trigger and listens for every insertion and notify the client?
How do you define "full"?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
IP connection:
createuser -U postgres -h localhost me
The default pg_hba.conf on Debian uses a Unix socket and peer
authentication, hence the error you're seeing.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
:=(SELECT MAX(ID) FROM TABLE_1);
select max(id) into seq from table_1;
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
12 matches
Mail list logo