Re: [SQL] [GENERAL] How to view the list of tables?

2005-02-16 Thread Shridhar Daithankar
On Tuesday 15 Feb 2005 3:46 pm, Konstantin Danilov wrote: > Hello, list! > I need to view the list of tables in a database. In MySQL I can do it with > the command "SHOW TABLES". What about PostgreSQL? Can I also see somehow > the datatypes of tables' fields? In psql, you can try '\dt' and '\d tab

Re: [SQL] [PERFORM] EXTERNAL storage and substring on long strings

2003-08-04 Thread Shridhar Daithankar
On 4 Aug 2003 at 12:14, Scott Cain wrote: > I forgot about searching--I suspect that application is why I faced > opposition for shredding in my schema development group. Maybe I should > push that off to the file system and use grep (or BLAST). Otherwise, I > could write a function that would se

Re: [SQL] [HACKERS] Our FLOAT(p) precision does not conform to spec

2003-06-18 Thread Shridhar Daithankar
On 16 Jun 2003 at 18:15, Tom Lane wrote: > This is a straightforward change and would not break pg_dump files, > since fortunately pg_dump always references the underlying types and > never refers to anything as FLOAT(p). But I wonder whether it is > likely to break many existing applications. Th