Dhaval Shah writes:
> Let me know why I am not getting similar results when the RHS is an
> IPV4 in IPV6 format vs, the RHS in IPV4 format.
AFAIR, the inet/cidr types consider IPv4 to be an independent set of
values that sort in front of all IPv6 values. The notion that IPv4
might be embedded in
I need some help in understanding why this is not working:
I have created a cidr_test table with datatypes cidr, varchar and bigint.,
rwdb=# \d cidr_test;
Table "public.cidr_test"
Column| Type | Modifiers
--+---+---
ip
Arnau Rebassa i Villalonga <[EMAIL PROTECTED]> writes:
>I have a server with 4GB of RAM and I wanted to know how much memory
> is being used by a PostgreSQL. To do so I have executed the following:
>ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 }
> END { print "Real:
Hi all,
I have a server with 4GB of RAM and I wanted to know how much memory
is being used by a PostgreSQL. To do so I have executed the following:
ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 }
END { print "Real: ",rss/1024"MB Virtual: ",vsz/1024"MB" }'
And the resul
Hi all,
I have a server with 4GB of RAM and I wanted to know how much memory
is being used by a PostgreSQL. To do so I have executed the following:
ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 }
END { print "Real: ",rss/1024"MB Virtual: ",vsz/1024"MB" }'
And the resul
>I have a server with 4GB of RAM and I wanted to know how much memory
> is being used by a PostgreSQL. To do so I have executed the following:
>ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 }
> END { print "Real: ",rss/1024"MB Virtual: ",vsz/1024"MB" }'
> And the resul
Hi all,
I have a server with 4GB of RAM and I wanted to know how much memory
is being used by a PostgreSQL. To do so I have executed the following:
ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 }
END { print "Real: ",rss/1024"MB Virtual: ",vsz/1024"MB" }'
And the resul
Paul Vogel <[EMAIL PROTECTED]> writes:
> So something is
> apparently different between the command line "createdb" command and the
> "create database" command.
Not a lot ... createdb just runs psql to issue a create database
command. One possibility is that you gave createdb a mixed-case
datab
I have a pg_dump of a database (without autocreation lines) that I
tried loading by using the commands:
createdb -T template0 -U postgres database; psql -U postgres
database < filename
I couldn't get it to connect via ODBC. But when I added the following
lines in the source file:
CR
: [EMAIL PROTECTED]
Subject: Re: [ADMIN] A question about Join?...
On Wed, 23 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez wrote:
> Hello Everybody?...
>
>
>
>Hey, i have a question about of the uses the joins
> in PostgreSQL.
>
> In SQL Server the joins i can use with the si
On Wed, 23 Jun 2004, [iso-8859-1] Jhonatas M. Rodríguez wrote:
> Hello Everybody?...
>
>
>
>Hey, i have a question about of the uses the joins
> in PostgreSQL.
>
> In SQL Server the joins i can use with the simbol(*),
> Example:. the right join is "field1=*field2"
>
> In Oracle the joins are w
Hello Everybody?...
Hey, i have a question about of the uses the joins
in PostgreSQL.
In SQL Server the joins i can use with the simbol(*),
Example:. the right join is "field1=*field2"
In Oracle the joins are with the simbol (+),
Example:. the left join is "field1(+)=field2"
What is the si
Jhonatas M. Rodríguez wrote:
Hey Everyone:
How are you?... i want to know if PostgreSQL have a
.NET provider for VS.NET with ADO.NET and OleDB.
open source:
http://gborg.postgresql.org/project/npgsql/projdisplay.php
commercial:
http://crlab.com/pgsqlnet/
I'm interesting to develoment with P
Hey Everyone:
How are you?... i want to know if PostgreSQL have a
.NET provider for VS.NET with ADO.NET and OleDB.
I'm interesting to develoment with PostgreSQL,
because PostgreSQL is a really good database
management.
Regards,
Jhonatas M. Rodríguez
If you list de processes using de command
ps ax |grep postgres
all the current connections in PostgresSQL are listed.
Raquel
On Wednesday 21 January 2004 03:21 pm, Anson Liu wrote:
> Dear friend,
>
> How to display the number of current connections in PostgreSQL?
> Thanks!
> Anson
>
> -
Dear friend,
How to display the number of current connections in PostgreSQL?
Thanks!
Anson
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
There are two interfaces that I know of.
1) pgAdmin II is a windows based interface to postgress but they
already have a alpha code for pgAdmin III wich will work on unix and
other platforms. http://www.pgadmin.org
2) phpPgAdmin which is a web based interface to postgres done in php.
Very coo
I am looking for a GUI interface offered by Postgresql if
you could help me with that I’d really appreciate it.
Thanks
M.Erfani
Eddy,
The command you need is:
psql> grant update on table_name to username;
Banghe
Dong Meng wrote:
> Dear Guys,
>
> May I have a question about the authorization of psql?
>
> By using '\z' in psql context, I can get the description of authorization about each
>table/view.
>
>
>
Dong Meng writes:
> Authoriztion switches are specified as above, but what should I do if
> I want to grant 'update' without 'delete' to some table/view?
Wait for release 7.2.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP
Dear Guys,
May I have a question about the authorization of psql?
By using '\z' in psql context, I can get the description of authorization about each
table/view.
r -- SELECT
w -- UPDATE/DELETE
a -- INSERT
R -- RULE
21 matches
Mail list logo