agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedMac Address
4+ messages / 4 participants
[nested] [flat]
* Mac Address
@ 2006-09-02 20:42 Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
0 siblings, 3 replies; 4+ messages in thread
From: Ezequias Rodrigues da Rocha @ 2006-09-02 20:42 UTC (permalink / raw)
To: pgsql-sql
Hi list,
It is possible to retrieve the MAC Address of a computer using a Postgresql
function like others:
http://www.postgresql.org/docs/8.1/static/functions-info.html
I can retrieve a ip of some statement connection but I didn't find how to
get the MAC Address. Is it possible ?
Regards
Ezequias
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Mac Address
@ 2006-09-02 22:34 Milen A. Radev <milen@radev.net>
parent: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Milen A. Radev @ 2006-09-02 22:34 UTC (permalink / raw)
To: pgsql-sql
Ezequias Rodrigues da Rocha написа:
> Hi list,
>
> It is possible to retrieve the MAC Address of a computer using a Postgresql
> function like others:
>
> http://www.postgresql.org/docs/8.1/static/functions-info.html
>
> I can retrieve a ip of some statement connection but I didn't find how to
> get the MAC Address. Is it possible ?
No - the client and the server communicate using TCP/IP as
transport/internet layer but that does not mean they use Ethernet as
network access layer.
--
Milen A. Radev
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Mac Address
@ 2006-09-02 23:24 Bruno Wolff III <bruno@wolff.to>
parent: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Bruno Wolff III @ 2006-09-02 23:24 UTC (permalink / raw)
To: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>; +Cc: pgsql-sql
On Sat, Sep 02, 2006 at 17:42:29 -0300,
Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
> Hi list,
>
> It is possible to retrieve the MAC Address of a computer using a Postgresql
> function like others:
MAC Addresses are generally only transferred within a subnet and you aren't
going to be able to get them in the general case.
> http://www.postgresql.org/docs/8.1/static/functions-info.html
>
> I can retrieve a ip of some statement connection but I didn't find how to
> get the MAC Address. Is it possible ?
What is it that you are really trying to accomplish? There might be some
other solution than having to get the mac address of a remote computer.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Mac Address
@ 2006-09-03 07:07 Andreas Kretschmer <akretschmer@spamfence.net>
parent: Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2 siblings, 0 replies; 4+ messages in thread
From: Andreas Kretschmer @ 2006-09-03 07:07 UTC (permalink / raw)
To: pgsql-sql
Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> schrieb:
> Hi list,
>
> It is possible to retrieve the MAC Address of a computer using a Postgresql
> function like others:
In the same subnet? Then you can use untrusted languages such as plperlu
or plsh to retrieve the MAC for a IP. (arp -a ip)
Btw.: please no HTML in eMails.
HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2006-09-03 07:07 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-02 20:42 Mac Address Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com>
2006-09-02 22:34 ` Milen A. Radev <milen@radev.net>
2006-09-02 23:24 ` Bruno Wolff III <bruno@wolff.to>
2006-09-03 07:07 ` Andreas Kretschmer <akretschmer@spamfence.net>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox