Keith Wong <[EMAIL PROTECTED]> writes:
> Anybody know how to compile pgaccess from postgres source files?
I think it's driven by configure --with-tcl.
regards, tom lane
Hello Everyone,
I have an Intel system with solaris 7 installed
on it. Now I have d/l'ed postgres 6.5.1 to install it
on my system.
1.) What all the utilities are needed before I start
compiling and installing the postgres s/w?. I mean
to say utilities like gmake. But I could no
Anybody know how to compile pgaccess from postgres source files?
It must be a configure option, but I can't find it.
Keith.
On Fri, 15 Sep 2000, Rommel B. Abaya wrote:
> type \d [tablename] at the psql console
And if you like that try:
\d+ [tablename]
Of course it's much more impressive if you've created any COMMENTs.
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED] Altoplanos Information Systems, Inc.
Hi,
try this:
testdb=#SELECT DISTINCT table_2.f1, table_1.f2, date('2000-08-22') AS
testdb-#date FROM table_1, table_2 WHERE table_1.f1 = table_2.f1;
Jerome Raupach wrote:
> testdb=#SELECT DISTINCT table_2.f1, table_1.f2, '2000-08-22' AS
> testdb-#date FROM table_1, table_2 WHERE table_1.f1 = t
Hi, there,
You just need type
psql> \d tablename
use
\? to get help
Michael Teter wrote:
> how can I get the schema of a table in psql?
>
> in oracle I would do "desc tablename". I remember sql
> server and ingres having a similar facility.
>
> right now the only way I seem to be able to get
I have a front end that builds queries based on a user selection of:
Match type (=, <, >, ~, ~~, etc)
Ignore/honor upper/lower case
Negate the comparison
I ended up putting the following operators in the backend so the
operators all
had parallel types of case/no-case options. This made the
I'm not sure this is the right list for this but maybe someone could point
me in the right direction.
We are getting some DB servers to test performance. I was wondering if
anyone knows where we can get a test script of sorts that would allow us to
check performance on each of the servers.
TIA
Jerome Raupach <[EMAIL PROTECTED]> writes:
> testdb=#SELECT DISTINCT table_2.f1, table_1.f2, '2000-08-22' AS
> testdb-#date FROM table_1, table_2 WHERE table_1.f1 = table_2.f1;
> ERROR: Unable to identify an ordering operator '<' for type 'unknown'
> Use an explicit ordering operator or m
type \d [tablename] at the psql console
Michael Teter wrote:
> how can I get the schema of a table in psql?
>
> in oracle I would do "desc tablename". I remember sql
> server and ingres having a similar facility.
>
> right now the only way I seem to be able to get the
> information is by usin
doh!
thanks so much. somehow I thought \h and \? were the
same, and I've only been doing \h :)
no wonder I couldn't find it.
michael
--- Patrik Kudo <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I think what you're looking for is
>
> \d
>
> and
>
> \d name_of_table
>
> You might also want to try
Hi!
I think what you're looking for is
\d
and
\d name_of_table
You might also want to try
\?
for a list of all psql commands
Regards,
Patrik Kudo
ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol
Känns det oklart? Fråga på!
On Fri, 15 Sep 2000, Michael Teter wrote:
> ho
testdb=#SELECT DISTINCT table_2.f1, table_1.f2, '2000-08-22' AS
testdb-#date FROM table_1, table_2 WHERE table_1.f1 = table_2.f1;
ERROR: Unable to identify an ordering operator '<' for type 'unknown'
Use an explicit ordering operator or modify the query
I must execute this query :
testd
how can I get the schema of a table in psql?
in oracle I would do "desc tablename". I remember sql
server and ingres having a similar facility.
right now the only way I seem to be able to get the
information is by using pgaccess.
I realize the definition of the table is probably
spread across
14 matches
Mail list logo
