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, Mich
#x27;select version()'
PostgreSQL 6.5.3 on i386-unknown-freebsd4.1, compiled by cc
uname -a
FreeBSD 4.1-RELEASE #0: Tue Aug 29 15:31:01 CEST 2000
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å!
Hi
try
COPY forum FROM 'datei.csv' USING DELIMITERS '|';
You should use either 'filename' OR stdin, not both.
Hope it helps.
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
Hi!
I've for a while now been using the != operator in my sql queries, but in
almost all examples I see <> instead. Are there any good reason to use
any instead of the other? I prefer !=, but if you convince me, I'll change to
what you other guys are using ;-)
Regards,
Patri
How many of the other dbms' out there have this "hardwired hack"? Is
something that's postgres-specific, or is it found in oracle and sqlserver
too?
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å!
I've never used functions in postgres, but the line
*resultp = *testo;
looks wrong to me. Shouldn't it be
strcpy(resultp, testo);
?
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 Thu, 12 Jul 2001
What you want to know is probably this:
Select XID, xi.DENOM, PRICE, FRT, CTID From XItem xi, Category c Where
xi.System=1 and xi.Category=c.Index
Regards,
Patrik Kudo
---(end of broadcast)---
TIP 2: you can get off all lists at once with the
ES (12);
INSERT INTO T (v) VALUES (3);
INSERT INTO T (v) VALUES (9);
INSERT INTO T (v) VALUES (4);
In that case you could do the following:
SELECT v FROM T ORDER BY v DESC LIMIT 3;
This will select the values, sort them in descending order and limit the
result to 3 rows.
I hope it helps.
Regar
, except for uniqueness on userid).
I belive this should be a trivial task, but I'm experience total lack of
insight here...
Comments?
/Patrik Kudo
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
e,
the userid-val combinations will be unique, but I want unique userids
with only the latest val for each userid.
/Patrik Kudo
> >
> > Hi,
> >
> > I have a table which basically looks like this:
> >
> > create table (userid text, val integer, ts timestamp);
> >
userid, ts DESC;
>
> See the DISTINCT ON example in the SELECT reference page for more info:
> http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/sql-select.html
Thanks!
I was trying some stuff with distinct on, but in combination with max(ts),
which obviously didn't work.
column index on both id and name? Both id and name are of type
"text".
TIA,
Patrik Kudo
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
straints: $1 FOREIGN KEY (userid) REFERENCES
person(userid) ON UPDATE NO ACTION ON DELETE CASCADE
alter table asdf drop constraint "$1";
Regards,
Patrik Kudo
rute solipa wrote:
hello,
does anyone nows how can i disable/enable table or column constraints?
in oracle it's possib
Hi Rob,
Try this:
select * from blah where stamp >= now()::date - 7;
I think it should work.
/Patrik Kudo
On Mon, 10 Jul 2000, Rob S. wrote:
> Hi all,
>
> I would like to say,
>
> "select * from blah where stamp >= 7 days ago"
>
> ...where the &
14 matches
Mail list logo
