Re: Date - Mailing list pgsql-novice
| From | cristi |
|---|---|
| Subject | Re: Date |
| Date | |
| Msg-id | 002801c1db96$8d5c5360$7201a8c0@dmhi.ct.ro Whole thread Raw |
| In response to | Date (cristi voinicaru <cristiv69@yahoo.com>) |
| List | pgsql-novice |
----- Original Message -----
From: "Jason Friedman" <jason@powerpull.net>
To: <pgsql-novice@postgresql.org>
Sent: Wednesday, April 03, 2002 4:46 PM
Subject: Re: [NOVICE] Date
> So that I can have more information, please do:
>
> SELECT * FROM table LIMIT 50;
>
> Please put on extended display (\x) if your table is wider than the
> screen.
>
> Also, do a \d table
salt=> select ma,nu,i,co,o1,sc,mo,da from a where da='03-31-2002';
10772|Buzoianu |S |33012CD| 8| 1|S |03-30-2002
14111|Banica |Gh |33012CD| 5| 1|S |03-30-2002
9496|Seitasan |M |43113AE| 0| 1|S |03-30-2002
16891|Apostol |x |33012CD| 8| 1|S |03-30-2002
8086|Vaduva |M |33012CB| 8| 1|S |03-30-2002
9503|Tudose |Gh.|33012CB| 8| 1|S |03-30-2002
15837|Simionescu |I |33012CB| 0| 1|S |03-30-2002
11767|Petre |I |33012CB| 8| 1|S |03-30-2002
15026|Nitu | |33012CB| 0| 1|S |03-30-2002
15009|Niculita | |33012CB| 8| 2|S |03-30-2002
12493|Mustafa |I |33012CB| 8| 1|S |03-30-2002
2489|Milea |I |33012CB| 5| 1|S |03-30-2002
3360|Melnic |G |33012CB| 8| 1|S |03-30-2002
2447|Luta |N |33012CB| 8| 1|S |03-30-2002
11141|Ibram |F |33012CB| 8| 1|S |03-30-2002
15820|Dusea |Ion|33012CB| 0| 1|S |03-30-2002
15748|Coman |P |33012CB| 8| 1|S |03-30-2002
15437|Ciobanu |I. |33012CB| 8| 1|S |03-30-2002
2330|Catarama |T |33012CB| 8| 1|S |03-30-2002
2859|Burciu |Gh |33012CB| 0| 1|S |03-30-2002
15676|Bulmaga |I |33012CB| 8| 1|S |03-30-2002
(1808 rows)
ERROR: parser: parse error at or near "/"
salt=> \d a
Table = a
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| ma | int4 |
4 |
| nu | varchar() |
15 |
| i | varchar() |
3 |
| pr | varchar() |
15 |
| co | varchar() |
7 |
| un | varchar() |
36 |
| di | varchar() |
36 |
| of | varchar() |
36 |
| lo | varchar() |
36 |
| de | varchar() |
36 |
| onn | int2 |
2 |
| mo | varchar() |
1 |
| sc | int2 |
2 |
| o1 | int2 |
2 |
| o2 | int2 |
2 |
| oa | int2 |
2 |
| da | date |
4 |
| dv | date |
4 |
| ov | time |
8 |
| dn | date |
4 |
| onv | time |
8 |
| op | int4 |
4 |
| v | varchar() |
1 |
+----------------------------------+----------------------------------+-----
--+
Indices: a_da
a_ma
salt=>
pgsql-novice by date: