Hi, does anyone know how to get the schema information
of a table. More specifically, I would like to know
1. which field(s) are primary keys?
2. the data type of each field of a table?
3. If a field is a foreign key, what field/table it
is referring to.
Thanks.
Wei
Am Mittwoch, 26. Mai 2004 00:36 schrieb Wei Shi:
Hi, does anyone know how to get the schema information
of a table. More specifically, I would like to know
1. which field(s) are primary keys?
2. the data type of each field of a table?
3. If a field is a foreign key, what field/table it
is
I'm trying to configure postfix to use the postgres database for lookups.
Since I have a localhost based server, I was going to use unix_sockets.
The postgres docs call for only a /directory.
unix_socket_directory (string)
Specifies the directory of the Unix-domain socket on which the
Tom Allison wrote:
I'm trying to configure postfix to use the postgres database for lookups.
Since I have a localhost based server, I was going to use unix_sockets.
The postgres docs call for only a /directory.
unix_socket_directory (string)
Specifies the directory of the Unix-domain socket
Barry wrote:
Hi All,
I am a newcommer to Postgresql, currently I am looking at moving
a Pick based application across to PostgreSQL.
I am using RH Linux and Postgresql 7.3.6
The test system I am using has a 2 channel raid card with a disk pack
connected to each channel. The OS and Postgresql sits
--On Tuesday, May 25, 2004 20:52:22 -0400 Tom Allison
[EMAIL PROTECTED] wrote:
How would I specify a field that's to be updated to current_time
everytime the row is created/altered?
Is there some way to put this 'update' property into the table instead of
running some query to do it?
You are
Doug McNaught wrote:
Tom Allison [EMAIL PROTECTED] writes:
How would I specify a field that's to be updated to current_time
everytime the row is created/altered?
Create a trigger. There are some good examples in the PL/pgSQL docs.
Is there some way to put this 'update' property into the table
Wei Shi wrote:
Is there a function interface to get this information
other than from psql comman line interface?
If you start psql with the '-E' switch, you'll see the queries it
generates to display the meta-data associated with the '\' command
you issue.
You may also query the tables and
This is great. Thanks.
Wei
--- Mike Mascari [EMAIL PROTECTED] wrote:
Wei Shi wrote:
Is there a function interface to get this
information
other than from psql comman line interface?
If you start psql with the '-E' switch, you'll see
the queries it
generates to display the meta-data