Howard Hiew <[EMAIL PROTECTED]> writes:
> Hi,
> I would like to know what is the sql statement that list all the tables
> name.
>
> For example in Oracle,
> 'SELECT TABLE_NAME from ALL_TABLES where owner="Oracle" ';
>
> What is the statement for Postgres?
> Thank you
>
> Best Regards,
> Howard
"Michael Wagner" <[EMAIL PROTECTED]> writes:
> We need to export an SQL database to Excel. Is this within your scope and =
> what might your cost be?
>
> Please respond to Dan Beach
Why not just save it to text CSV format and Excel can then easily
import it.
--
Prasanth Kumar
[EMAIL PROTECT
"Gary J. Farmer" <[EMAIL PROTECTED]> writes:
> >> I think the order thing will work though I have no choice of using
> >> numbering for the address_type as I am working off a pre-existing
> >> database. They are using a mnemonic char type. I am essentially batch
> >> downloading and processin
limit 1 ;
>
> sure you can change the limit if you wish more addresses.
> hope that helps
> Omid Omoomi
>
> >From: [EMAIL PROTECTED] (Prasanth A. Kumar)
> >To: [EMAIL PROTECTED]
> >Subject: [SQL] Select by priority
> >Date: 15 Jul 2000 10:11:43 -0700
>
I need some suggestions on how to construct a particular select that I
need. I have a table of addresses where the primary key is the
persons_id and a address_type field. The address_type field is a
character which specifies whether the address is for the home, work,
or mailing. A person can have
