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
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
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
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
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
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
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
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
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
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.
Anybody know how to compile pgaccess from postgres source files?
It must be a configure option, but I can't find it.
Keith.
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
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
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
14 matches
Mail list logo
