use this
Last login: Fri Jan 9 16:54:14 from 192.168.2.117
[EMAIL PROTECTED] ssakkaravel]$ psql -E training test
* QUERY **
SELECT usesuper FROM pg_user WHERE usename = 'test'
**
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for
On Fri, 9 Jan 2004, Bing Du wrote:
> Greetings,
>
> How can I see the layout of a table in PostgreSQL 7.4? I've checked
> several books and on-line documents, but was not able to figure out how
> PostgreSQL does 'describe ' like it's done in other databases.
If in psql, use the \d commands (\?
--On Friday, January 09, 2004 17:05:37 -0600 Bing Du <[EMAIL PROTECTED]>
wrote:
Greetings,
How can I see the layout of a table in PostgreSQL 7.4? I've checked
several books and on-line documents, but was not able to figure out how
PostgreSQL does 'describe ' like it's done in other databases.
Greetings,
How can I see the layout of a table in PostgreSQL 7.4? I've checked
several books and on-line documents, but was not able to figure out how
PostgreSQL does 'describe ' like it's done in other databases.
Thanks in advance for any help.
Bing
---(end of broadcas
On Friday 09 January 2004 02:13, [EMAIL PROTECTED] wrote:
> Hi,
>
Just realised this question is also posted under COPY command. Ignore me.
--
Richard Huxton
Archonet Ltd
---(end of broadcast)---
TIP 6: Have you searched our list archives?
On Friday 09 January 2004 02:13, [EMAIL PROTECTED] wrote:
> Hi,
>
>
> i try to load data from flat file (comma delimiter format) into
> temporary table . i use COPY command as below:
>
> dwnc=# copy biosadm.custdo_temp
> dwnc-# from '/home/bios/customer_data/CustomerDO_new.CSV'
> dwnc-# WITH DELI
On Fri, 9 Jan 2004, Tom Lane wrote:
> Richard Huxton <[EMAIL PROTECTED]> writes:
> > Since your error seems to be complaining about a space, I'd guess you've got
> > other than numeric values in _aaa.
>
> In fact, with a bit of experimentation I see the same error message:
>
> regression=# sel
Richard Huxton <[EMAIL PROTECTED]> writes:
> Since your error seems to be complaining about a space, I'd guess you've got
> other than numeric values in _aaa.
In fact, with a bit of experimentation I see the same error message:
regression=# select to_number('12345', '9');
to_number
On Jan 9, 2004, at 4:15 PM, [EMAIL PROTECTED] wrote:
Hi,
i got an error below after running copy command . the table structure
as
following :
Table "biosadm.custinv_temp
Column| Type |
-+---+-
yr | integer |
custname| text
On Friday 09 January 2004 07:35, Daniel Lau wrote:
> Hi all,
>
> Thank you for reading this mail.
>
> I am trying to do the following:
> Extract the first half of _aaa and put it in column _bbb
> Varchar[10] | Double Precision
> _aaa _bbb
> 1234567890
> I used two functions t
Daniel Lau <[EMAIL PROTECTED]> writes:
> I used two functions to do it: substring() and to_number(). The SQL is
> like this:
> UPDATE _table SET _bbb = to_number(substring(_aaa from 1 for 5), '9');
> The machine fails me and said
> ERROR: invalid input syntac for type numeric: " "
Works for me
Hi,
i got an error below after running copy command . the table structure as following :
Table "biosadm.custinv_temp
Column | Type |
-+---+-
yr | integer |
custname | text |
invstatus | text |
custlo
Hi all,
Thank you for reading this mail.
I am trying to do the following:
Extract the first half of _aaa and put it in column _bbb
Here is the table, named: _table:
Varchar[10] | Double Precision
_aaa_bbb
_
1234567890
I used two function
13 matches
Mail list logo
