473,320 Members | 1,921 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Are queries different between sql and postgresql?

Hi all,

I am a new member of this forum and looking for your support towards my discussion..

I want to know that the queries we are using in sql is entirely different postgresql?

And the second thing is in sql, we use "decription tablename" or "show columns from tablename" for collecting information about fieldnames of a table...

I have tried the same in postgresql for getting my field name but i am getting error message as "command not supported"..

Kindly forward me some more details regarding this...

thanks..
Kevin..
Aug 17 '07 #1
2 2569
michaelb
534 Expert 512MB
Welcome to the Forum, Kevin.

I think that when you say "sql" you actually mean MySQL database server.

Here are the things to remember:
SQL, as language, is defined by standards.
The original SQL standard was completed as a USA ANSI (American National Standards Institute) standard in 1986, and adopted as an ISO (International Standards Organization) standard in 1987. Expansions and revisions were released in 1989 and 1992.
Then there was SQL 1999, which was developed by the INCITS Technical Committee H2 on Database. This committee develops standards for the syntax and semantics of database languages.
Since then the SQL standard kept evolving, I think the latest draft (or standard?) is SQL 2003.

f you are really interested run a Qoogle serach for "sql standards" and you'll have enough papers to read for a very long time!

Any major database vendor provides SQL which for most parts is compliant with the SQL standard (one of them, anyway), but typically has something that's called "vendor extensions" - non-standard commands that they add for convenience.
Sometimes they also choose not to comply with the SQL standards, I think a good example would be how Oracle treats the NULL values.

I did not check, but I'm pretty sure that things like "show columns from tablename" are not coming from the SQL standards, these are vendor provided extensions, and as such can be different from one database to another.

The easiest way to display the table schema in PostgreSQL is to use the metacommand \d in psql.

You may also want to look at psql man page and at this posting for more info.
Aug 18 '07 #2
Thank you michael for your informative reply...

The links you have guide me was useful to me,to understand my stance better..

keep the good work going...

regards,
kevin..
Aug 21 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: Alejandro Forero Cuervo | last post by:
Hello. I'm new to PostgreSQL and I'm using it for some project. I am currently creating an entity engine that provides a web interface, which is oriented towards end users, to...
13
by: Anton.Nikiforov | last post by:
Hello everybody! Does someone know how to build hierarchical queries to the postgresql? I have a table with tree in it (id, parent) and need to find a way from any point of the tree to any...
0
by: Zlatko Matiæ | last post by:
Hi everybody! Recently I was struggling with client/server issues in MS Access/PostgreSQL combination. Although Access is intuitive and easy to use desktop database solution, many problems...
3
by: MaRCeLO PeReiRA | last post by:
Hi All, Is there any way to log (save) "all" the queries (select, insert, updade, everything) executed on a database, in a table?? Regards, Marcelo
34
by: Karam Chand | last post by:
Hello I have been working with Access and MySQL for pretty long time. Very simple and able to perform their jobs. I dont need to start a flame anymore :) I have to work with PGSQL for my...
2
by: David Boone | last post by:
I've been trying to create functions with postgres, but it seems that queries run within a function take wayyy too long to complete. The increased time seems to be in the actual queries, not...
0
by: Ulrich Wisser | last post by:
Hello, my web application grows slower and slower over time. After some profiling I came to the conclusion that my SQL queries are the biggest time spenders (25 seconds). Obviously I need to...
6
by: SR | last post by:
As a starter project for learning Python/PostgreSQL, I am building a Books database that stores information on the books on my bookshelf. Say I have three tables. Table "books" contains rows...
0
by: Christoph Haas | last post by:
Hi, list... I have written an application in Perl some time ago (I was young and needed the money) that parses multiple large text files containing nested data structures and allows the user to...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.