Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

Is there a mysql equivalent of show create table in postgres???

⇧
0
⇩
70 views

Hi, is there a mysql equivalent of SHOW CREATE TABLE in postgres? Is this possible? If not what is the next best solution?

I need the statement because I use it to create the table on an remote server (over WCF).

Thanks, Vasja

mysql table postgres create
asked February 6, 2011 3:49 pm CST
vlebar
posted via ServerFault

2 Answers

⇧
1
⇩
 

pg_dump:

pg_dump --schema-only -t tablename

or use PostgreSQL GUI Tools(pgAdmin,phpPgAdmin,etc.)

answered February 6, 2011 4:23 pm CST
alvosu
⇧
0
⇩
 

You can try to trace in the PostgreSQL log file what "pg_dump -t table -s" really does.Then you can use the same method to write your own sql function.

answered February 7, 2011 1:39 am CST
RJS

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
Can I change the datatype for the "Create Table" field in the Show Create Table function in MySQL?
January 10, 2011
Foreign key constraints missing from SHOW CREATE TABLE output
December 28, 2010
Redis newbie - equivalent approach to mysql table
February 6, 2011
Create table from select then alter table by adding an auto increment column in mysql
January 11, 2011
Mysql create table based on another table including indexes
January 25, 2011
MySQL create table containing values from a column in another table.
January 28, 2011
MySQL - Aren't these privileges enough to create a table?
January 3, 2011
How to create index in two table mysql?
January 13, 2011
Convert Simple T-SQL DDL to MySQL DDL (Create Table)
January 6, 2011
Mysql create a table character sets
January 25, 2011
How to create mysql table with many hasMany association in CakePHP?
January 18, 2011
Using MySQL, I'm attempting to create a table in a db, and then insert into, but am getting a 'syntax' error
January 13, 2011
Django SQL works in MySQL, Postgres 9.0(?) not on Postgres 8.4(?)
January 27, 2011
Show TABLE status and return 1 field
January 4, 2011
Speeding up a group by date query on a big table in postgres
January 12, 2011
Best-performing method for associating arbitrary key/value pairs with a table row in a Postgres DB?
January 19, 2011
Comments show up in database, but only show up on my index page after a refresh.
January 1, 2011
With SQlite, show do you show current PRAGMA settings?
December 24, 2010
PHP / MySQL - Create array of distinct values, query db table for data associated with those values, and loop for each
January 25, 2011
Pg_query_params equivalent in mysql?
January 21, 2011
Is there a MySQL equivalent of sprintf?
January 4, 2011
Create this table using my sql
February 1, 2011
Connect to Postgres remotely, open port 5432 for Postgres in iptables
January 6, 2011
MySQLi Equivalent Of MySQL Code
February 2, 2011
How to use constants in SQL CREATE TABLE?
December 31, 2010
Mysql equivalent to access stored queries
February 1, 2011
[Solved] SQL CREATE TABLE Error
January 9, 2011
Trigger: after insert create a new table
January 7, 2011
How to create paging with multi different table?
February 1, 2011
Hibernate: hbm2ddl.auto does not create table
December 28, 2010